Writing Unicode to a MySQL table

[khovorka]

Hello,

I have looked on the web for what I can find and still can't get Unicode to
successfully write to my MySQL table.

I have implemented the various options identified but perhaps something
is slightly out of whack?????

I have a script that reads and XML file and successfully displays the Unicode
in the echoed query string I want to write to the database. I just can't get
the info written to the table. The fields are set to utf8_unicode_ci and that
is also collation for the table.

I am attaching an image (.jpg file) of the query that is correct and also shows the error message I display. I am also including the code that runs with all the changes. the file was renamed to xml.txt from xml.php.

If anyone can spot the problem I would appreciate any assistance as this is the
first time I have tried to write unicode to a database and help is appreciated.

Thanks,

Kim H.

[NogDog]

You many need to do the following after connecting to the DB and before any other queries. (I didn't look at the attachments, so don't know if you're doing this or not.)

mysql_query("SET NAMES 'utf8' COLLATE 'utf8_unicode_ci'");

FWIW, here's what I know about the subject: http://www.charles-reace.com/blog/2008/10/03/utf8-in-php-and-mysql/