Edit report at https://bugs.php.net/bug.php?id=60818&edit=1
ID: 60818 Updated by: ssuffic...@php.net Reported by: wrobel at wsb-nlu dot edu dot pl Summary: Problem storing UTF data Status: Open Type: Bug Package: PDO related PHP Version: Irrelevant Block user comment: N Private report: N New Comment: This will require a re-write of the PDO_DBLIB to allow the use of the "encoding" option. After that, all queries and parameter will require you to encode them before binding with utf8_encode(). You will also have to decode them using utf8_decode() when returned from the server. I was working to bring full Unicode support to the driver, but it would have broken so much code I had to rethink the strategy. Previous Comments: ------------------------------------------------------------------------ [2012-01-24 11:32:39] redman dot naw at gmail dot com Hi, -you should use utf8_decode to convert UTF8 character to ISO-8859-1(latin-1) character - i use this function with MySQL, that's work :D ------------------------------------------------------------------------ [2012-01-20 12:04:20] wrobel at wsb-nlu dot edu dot pl Description: ------------ I have a problem storing UTF data on MSSQL using pdo_dblib. In the following query: EXECUTE p_proc id = :id, @name = :name I cannot bind the ":name" param using the N'string' notation required by SQL Server (see http://support.microsoft.com/kb/239530) You cannot get around this by typing: EXECUTE p_proc id = :id, @name = N:name because binding fails on N:name The same problem happens with qoute function - it allways quotes with '' a never with N'' - perhaps there should be a new param like PDO::PARAM_STR to tell that with deal with a Unicode value? ------------------------------------------------------------------------ -- Edit this bug report at https://bugs.php.net/bug.php?id=60818&edit=1
