note 109439 added to ref.pdo-dblib

For people with issues inserting UTF-8 / Unicode data using DBLIB, you can't do this natively - but you can workaround the problem by converting the data first. e.g. inserting into a nvarchar column with collation Latin1_General_CI_AS ... $res = $db->prepare($sql); $res->bindValue(':value', iconv('UTF-8', 'ISO8859-1', $value); ... ---- Server IP: 69.147.83.197 Probable Submitter: 94.192.233.149 ---- Manual Page -- http://www.php.net/manual/en/ref.pdo-dblib.php Edit -- https://master.php.net/note/edit/109439 Del: integrated -- https://master.php.net/note/delete/109439/integrated Del: useless -- https://master.php.net/note/delete/109439/useless Del: bad code -- https://master.php.net/note/delete/109439/bad+code Del: spam -- https://master.php.net/note/delete/109439/spam Del: non-english -- https://master.php.net/note/delete/109439/non-english Del: in docs -- https://master.php.net/note/delete/109439/in+docs Del: other reasons-- https://master.php.net/note/delete/109439 Reject -- https://master.php.net/note/reject/109439 Search -- https://master.php.net/manage/user-notes.php