0

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)

Edited by Venom Rush: n/a

4
Contributors
6
Replies
8
Views
8 Years
Discussion Span
Last Post by Venom Rush
0

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...

1

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.

Votes + Comments
Thanks for your help ;)
0

Hi guys

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.

I'm going to test this on another database.

0

Ok, so it seems it's the server setup. I've tested the same pages on one of our own servers and it's working fine with special characters.

Thanks again to all of you that posted.

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.