ID: 37668 Updated by: [EMAIL PROTECTED] Reported By: eric dot potvin at zendphp dot com -Status: Open +Status: Bogus Bug Type: MySQLi related Operating System: WIN32 & FREEBSD PHP Version: 5.1.4 New Comment:
This is what MySQL API call returns and there is nothing we can do about it. Please report it to MySQL developers. Previous Comments: ------------------------------------------------------------------------ [2006-06-01 23:46:52] eric dot potvin at zendphp dot com Description: ------------ The mysqli_fetch_fields dosen't take the correct field type for the ENUM and SET type. Reproduce code: --------------- Create a table with a ENUM type with value like 'True', 'False' and default value to True. do : $finfo = mysqli_fetch_field($result) you will get : $finfo->type = 254 So, a STRING. - MYSQLI_TYPE_STRING and with no default value. Same thing for the set type. Expected result: ---------------- The $finfo->type should have 247 (MYSQLI_TYPE_ENUM) as value. or 248 (MYSQLI_TYPE_SET) as value for a SET type Actual result: -------------- array(0) { } ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=37668&edit=1