Bug #60818 [NEW]: Problem storing UTF data

From: Operating system: PHP version: Irrelevant Package: PDO related Bug Type: Bug Bug description:Problem storing UTF data 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 bug report at https://bugs.php.net/bug.php?id=60818&edit=1 -- Try a snapshot (PHP 5.4): https://bugs.php.net/fix.php?id=60818&r=trysnapshot54 Try a snapshot (PHP 5.3): https://bugs.php.net/fix.php?id=60818&r=trysnapshot53 Try a snapshot (trunk): https://bugs.php.net/fix.php?id=60818&r=trysnapshottrunk Fixed in SVN: https://bugs.php.net/fix.php?id=60818&r=fixed Fixed in SVN and need be documented: https://bugs.php.net/fix.php?id=60818&r=needdocs Fixed in release: https://bugs.php.net/fix.php?id=60818&r=alreadyfixed Need backtrace: https://bugs.php.net/fix.php?id=60818&r=needtrace Need Reproduce Script: https://bugs.php.net/fix.php?id=60818&r=needscript Try newer version: https://bugs.php.net/fix.php?id=60818&r=oldversion Not developer issue: https://bugs.php.net/fix.php?id=60818&r=support Expected behavior: https://bugs.php.net/fix.php?id=60818&r=notwrong Not enough info: https://bugs.php.net/fix.php?id=60818&r=notenoughinfo Submitted twice: https://bugs.php.net/fix.php?id=60818&r=submittedtwice register_globals: https://bugs.php.net/fix.php?id=60818&r=globals PHP 4 support discontinued: https://bugs.php.net/fix.php?id=60818&r=php4 Daylight Savings: https://bugs.php.net/fix.php?id=60818&r=dst IIS Stability: https://bugs.php.net/fix.php?id=60818&r=isapi Install GNU Sed: https://bugs.php.net/fix.php?id=60818&r=gnused Floating point limitations: https://bugs.php.net/fix.php?id=60818&r=float No Zend Extensions: https://bugs.php.net/fix.php?id=60818&r=nozend MySQL Configuration Error: https://bugs.php.net/fix.php?id=60818&r=mysqlcfg