mysqli_field_type returns a number [duplicate]

This question already has answers here: 开发者_JS百科 PHP mysqli_fetch_field data type (4 answers) Closed 4 years ago.

When I call mysqli_field_type it returns a number, which I assume relates to the type. Does anyone have a list of types and their corresponding numbers? I am in particular trying to find out if the data type is numerical or text (if that makes a difference).

---

Can be useful to someone, use this function:

$type = mysqli_fetch_field_direct($result, $i)->type;

Find out more: result->fetch_field_direct