#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: 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. Previous Comments: ------------------------------------------------------------------------ [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