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

ID: 38760 Updated by: tony2001@php.net Reported By: aireater at gmail dot com -Status: Open +Status: Feedback Bug Type: MSSQL related Operating System: Windows 2003 Server PHP Version: 5.1.6 New Comment: 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. Previous Comments: ------------------------------------------------------------------------ [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