mysql and unicode

[quantm]

Hi everybody
I have problem with storing unicode data in mysql database
- The field type in database is text.
- When I store data submitted from a form, the data in database is not in NCR format (I want to store them in NCR format).
- I have correctly type unicode characters in the input form.

Anyone could tell me whether the META tag (in header section of a html page) in the input form can affect the unicode data i want to store in my database. If not, please show me how to store unicode data in NCR format in mysql database.
(<META...charset=utf-8> or <META... charset=iso-8859-1...>)

Thank you in advance!

[jatar_k]

not something i have worked with much so i am not really. I think there were a few threads around about it but none of them seem to be overflowing with answers.

anyone have any ideas?

[Timotheos]

I'm interested in this too as I'm just embarking on a project that will need to use Unicode.

What version of MySQL do you have?

This is from the manual.

1.6.1 Features Available From MySQL 4.1
Internationalisation
- To support our ever expanding user base using local languages in applications, the MySQL software now offers extensive Unicode (UTF8) support.
- Character sets can now be defined per column, table, and database. This allows for a high degree of flexibility in application design, particularly for multi-language web sites.

[quantm]

Mysql version is mysql-4.0.11-gamma for windows
If yo know where I can get information about mysql and unicode, please let me know.

Thank you for your help!