From: robert dot butler at hoa-management dot com Operating system: Linux PHP version: Irrelevant Package: MySQLi related Bug Type: Bug Bug description:mysqli_fetch_field_direct returns incorrect length on UTF8 fields
Description: ------------ When using UTF8 in the database (mySQL 5.5.24-0ubuntu0.12.04.1), fields defined as a certain length aren't returned as the correct length by mysqli_fetch_field_direct. IOW, a char(32) field is shown as actually being 96 chars long because it's 32 * 3 (3 bytes per char instead of one). The older mysql_field_len correctly reports the length. Test script: --------------- // Assuming a single table with a single field 'test' defined as char(32) // and UTF-8 charset. $connection = = mysqli_connect ('localhost', 'user', 'password'); $query = "SELECT test FROM test_table LIMIT 1"; $result = mysqli_query ($connection, $query); $field_info = mysqli_fetch_field_direct ($result, 0); echo $field_info -> length; Actual result: -------------- Returns 96; should be 32. -- Edit bug report at https://bugs.php.net/bug.php?id=62426&edit=1 -- Try a snapshot (PHP 5.4): https://bugs.php.net/fix.php?id=62426&r=trysnapshot54 Try a snapshot (PHP 5.3): https://bugs.php.net/fix.php?id=62426&r=trysnapshot53 Try a snapshot (trunk): https://bugs.php.net/fix.php?id=62426&r=trysnapshottrunk Fixed in SVN: https://bugs.php.net/fix.php?id=62426&r=fixed Fixed in SVN and need be documented: https://bugs.php.net/fix.php?id=62426&r=needdocs Fixed in release: https://bugs.php.net/fix.php?id=62426&r=alreadyfixed Need backtrace: https://bugs.php.net/fix.php?id=62426&r=needtrace Need Reproduce Script: https://bugs.php.net/fix.php?id=62426&r=needscript Try newer version: https://bugs.php.net/fix.php?id=62426&r=oldversion Not developer issue: https://bugs.php.net/fix.php?id=62426&r=support Expected behavior: https://bugs.php.net/fix.php?id=62426&r=notwrong Not enough info: https://bugs.php.net/fix.php?id=62426&r=notenoughinfo Submitted twice: https://bugs.php.net/fix.php?id=62426&r=submittedtwice register_globals: https://bugs.php.net/fix.php?id=62426&r=globals PHP 4 support discontinued: https://bugs.php.net/fix.php?id=62426&r=php4 Daylight Savings: https://bugs.php.net/fix.php?id=62426&r=dst IIS Stability: https://bugs.php.net/fix.php?id=62426&r=isapi Install GNU Sed: https://bugs.php.net/fix.php?id=62426&r=gnused Floating point limitations: https://bugs.php.net/fix.php?id=62426&r=float No Zend Extensions: https://bugs.php.net/fix.php?id=62426&r=nozend MySQL Configuration Error: https://bugs.php.net/fix.php?id=62426&r=mysqlcfg