how to insert the unicode to mysql?

Hi all!

i try to insert the unicode to mysql by using INSERT statement, but data that inserted is not unicode it is latin character not code of uncode.
so how can i insert unicode from php.

best regards,
thirith

MySQL natively stores everything as Unicode starting with 4.1. But I believe the PHP DB drivers transcode, because PHP really only supports ISO-8859-1.

Quote:

---

Originally Posted by CornedBee

MySQL natively stores everything as Unicode starting with 4.1. But I believe the PHP DB drivers transcode, because PHP really only supports ISO-8859-1.

---

How should i do if i want to insert the unicode V4 to Mysql database through php?
i try to use decode and encode but it is not work.

You just need to treat unicode characters as integers in your applications. Heres some examples of how its done:

http://www.randomchaos.com/document....hp_and_unicode