Bug #60818 [Com]: Problem storing UTF data

Edit report at https://bugs.php.net/bug.php?id=60818&edit=1 ID: 60818 Comment by: redman dot naw at gmail dot com 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: 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 Previous Comments: ------------------------------------------------------------------------ [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