Question on MySQL

[Anon]

Dear all,

I want to use MySQL to store chinese, english and japanese information. Can anyone tell me does MySQL support database in UNICODE and is it support well?

Thanks
Bryan
www.mosotech.com

[Anon]

Hi,

MySQL does not afaik support unicode characters (I have been trying to do something similar recently.)

You can use HTML extended characters to try to store the language within a normal textfield, bearing in mind that each 'extended' character will take up 6 normal ASCII characters when storing in a text type field.

(an extended character looks like: &10203; or somesuch - If using a webbrowser to view these characters, you will need the correct language pack installed.)

Hope that helps,