I have a database that needs to hold names of people from all around the world. Some names have special characters in them such as é and ¢
Is there a character set I can use that will accept any character no matter what language it is (with the exception of non-English looking characters like chinese characters for instance)
Last edited by Venom Rush; Nov 6th, 2009 at 6:48 am.
Am I the first person in MySQL's entire life to need this sort of thing? o.O
Surely someone before me has run into this problem. I thought utf8_unicode_ci would do the trick or utf8_general_ci but neither of them work.
There must be some encoding set that I can use to accept worldwide characters...
my db is simple, numeric data only, but i went here, MYSQL Charsets to find out how to display other character sets, it was complicated, thats when I decided to set numeric tables (chickened out)
Is there a character set I can use that will accept any character no matter what language it is (with the exception of non-English looking characters like chinese characters for instance)
UTF-8 (utf8_general_ci) should work fine for that. Even for the Chinese characters.
I've created blog software in the past, using UTF-8, that I used to post content in multiple languages, including: English, Icelandic, Russian, Japanese. All of them worked perfectly.
If UTF-8 didn't work for you, odds are that the problem was not with MySQL itself, but rather your method of populating/retrieving the data from MySQL.
Thanks for all the input. My suspicions lie with the hosting company. We've had numerous issues before and the problem was always something that they hadn't setup correctly.
Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.
This thread is more than three months old
No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.
Marked 
