Bug #74955 [NEW]: Connection with UTF-8 return wrong String size

From: valentn at microtec dot fr Operating system: All PHP version: 7.1.7 Package: PDO Firebird Bug Type: Bug Bug description:Connection with UTF-8 return wrong String size Description: ------------ When I select char field in my database, it's returned with a size equivalent of storage bytes size. For utf8 char(3) return String length is 12. (3 char * 4bytes = 12) Test script: --------------- SQL : CREATE TABLE COMMERCIAUX ( ACTIF CHAR(3) CHARACTER SET 'UTF8' ); INSERT INTO COMMERCIAUX(ACTIF) VALUES ('Oui'); <?php $connection = new PDO('firebird:dbname=localhost/3050:MIASERVER;charset=utf8;encoding=UTF8', 'SYSDBA', 'masterkey'); $stmt = $connection->query('SELECT actif FROM commerciaux'); $result = $stmt->fetchAll(); ?> Expected result: ---------------- [ "ACTIF" => "Oui", 0 => "Oui", ], [ "ACTIF" => "Oui", 0 => "Oui", ], [ "ACTIF" => "Non", 0 => "Non", ], Actual result: -------------- You can see they spaces after text [ "ACTIF" => "Oui ", 0 => "Oui ", ], [ "ACTIF" => "Oui ", 0 => "Oui ", ], [ "ACTIF" => "Non ", 0 => "Non ", ], -- Edit bug report at https://bugs.php.net/bug.php?id=74955&edit=1 -- Try a snapshot (PHP 5.4): https://bugs.php.net/fix.php?id=74955&r=trysnapshot54 Try a snapshot (PHP 5.5): https://bugs.php.net/fix.php?id=74955&r=trysnapshot55 Try a snapshot (trunk): https://bugs.php.net/fix.php?id=74955&r=trysnapshottrunk Fixed in SVN: https://bugs.php.net/fix.php?id=74955&r=fixed Fixed in release: https://bugs.php.net/fix.php?id=74955&r=alreadyfixed Need backtrace: https://bugs.php.net/fix.php?id=74955&r=needtrace Need Reproduce Script: https://bugs.php.net/fix.php?id=74955&r=needscript Try newer version: https://bugs.php.net/fix.php?id=74955&r=oldversion Not developer issue: https://bugs.php.net/fix.php?id=74955&r=support Expected behavior: https://bugs.php.net/fix.php?id=74955&r=notwrong Not enough info: https://bugs.php.net/fix.php?id=74955&r=notenoughinfo Submitted twice: https://bugs.php.net/fix.php?id=74955&r=submittedtwice register_globals: https://bugs.php.net/fix.php?id=74955&r=globals PHP 4 support discontinued: https://bugs.php.net/fix.php?id=74955&r=php4 Daylight Savings: https://bugs.php.net/fix.php?id=74955&r=dst IIS Stability: https://bugs.php.net/fix.php?id=74955&r=isapi Install GNU Sed: https://bugs.php.net/fix.php?id=74955&r=gnused Floating point limitations: https://bugs.php.net/fix.php?id=74955&r=float No Zend Extensions: https://bugs.php.net/fix.php?id=74955&r=nozend MySQL Configuration Error: https://bugs.php.net/fix.php?id=74955&r=mysqlcfg