#38760 [Fbk->Opn]: php_mssql fails to convert multi-byte UTF-8 to UCS-2

ID: 38760 User updated by: aireater at gmail dot com Reported By: aireater at gmail dot com -Status: Feedback +Status: Open Bug Type: MSSQL related Operating System: Windows 2003 Server PHP Version: 5.1.6 New Comment: This is a sample script to reproduce the issue. Create a table with a "name" column of a varchar type only before testing. The string "DD" means the string is consisted of multi-byte UTF-8 cahracters. Some are inserted correctly, but most of time, inserted strings are not correctly shown on the screen because they are not correctly inserted in UCS-2. This script is for MS SQL Server 2005 Express. <?php $server = "localhost\sqlexpress"; $username = "username"; $password = "password"; $sqlconnect = mssql_connect($server, $username, $password); $sqldb = mssql_select_db("testdb",$sqlconnect); $str = 'DD'; $sqlquery = "insert into testtable (name) values('".$str."');"; $results = mssql_query($sqlquery); ?> <html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> </head> <?php $result = mssql_query("SELECT * FROM testtable"); while ($row=mssql_fetch_array($result)){ echo $row['name']."<br>\n";} mssql_close($sqlconnect); ?> Previous Comments: ------------------------------------------------------------------------ [2006-09-09 12:12:25] tony2001@php.net Thank you for this bug report. To properly diagnose the problem, we need a short but complete example script to be able to reproduce this bug ourselves. A proper reproducing script starts with <?php and ends with ?>, is max. 10-20 lines long and does not require any external resources such as databases, etc. If the script requires a database to demonstrate the issue, please make sure it creates all necessary tables, stored procedures etc. Please avoid embedding huge scripts into the report. ------------------------------------------------------------------------ [2006-09-09 12:04:30] aireater at gmail dot com Set mb_internal_encoding to UTF-8, and send an INSERT statement, that inserts a multi-byte string in UTF-8 to a varchar culumn, then an inserted string get garbage. It's not converted to UCS-2 that MS SQL Server supports to store an unicode string. ------------------------------------------------------------------------ [2006-09-09 10:39:29] tony2001@php.net Not enough information was provided for us to be able to handle this bug. Please re-read the instructions at http://bugs.php.net/how-to-report.php If you can provide more information, feel free to add it to this bug and change the status back to "Open". Thank you for your interest in PHP. ------------------------------------------------------------------------ [2006-09-09 01:30:35] aireater at gmail dot com Description: ------------ On PHP 5.1.6 Windows binary with php_mbstring and php_mssql.dll enabled, it fails to convert multi-byte UTF-8 strings to UCS-2 srtings. I've tried MS SQL Server 2005 Express and Standard but no success. On Windows 2003 Server. I've also tried several ntwdblib.dll but in vain. Expected result: ---------------- Should correctly convert multi-byte UTF-8 strings to UCS-2. Actual result: -------------- Most of single byte UTF-8 strings seem to be stored in the database but most of multi-byte UTF-8 strings get garbage. ------------------------------------------------------------------------ -- Edit this bug report at http://bugs.php.net/?id=38760&edit=1