I did not know about being able to stoe utf-8 in 8bit db... interesting. I noticed various utf-8 formats in MySQL 4.1.3. I used utf8-general is this what you would advise?
--tony
Tony Wood : twitter.com/tonywood
Vision with Technology
Experts in eZ Publish consulting & development
I'm not entirely sure what they mean about utf8-general, I have never heard about this before.
I found this page on mysql.com which explains the different collations (sorting) based on language.
http://dev.mysql.com/doc/mysql/en/Charset-Unicode-sets.html It could be related to that, do you know of a page on mysql.com that explains utf8-general?
Another interesting property of UTF-8 is that when you are only using characters from ASCII (7bit, 0-127) it will only store one byte and is fully compatible with older ASCII based programs.