 |  |  |  |  |  |  |  |
Universal character set?
Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases
Thread Solved |
•
•
Join Date: Oct 2007
Posts: 260
Reputation: 
Solved Threads: 2
Posting Whiz in Training
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)
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; 17 Days Ago at 6:48 am.
This user has a spatula. We don't know why, but we are afraid.
•
•
Join Date: Oct 2007
Posts: 260
Reputation:
Solved Threads: 2
Posting Whiz in Training
0
#2 17 Days Ago
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...
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...
This user has a spatula. We don't know why, but we are afraid.
-1
#3 17 Days Ago
Should be possible, because this site supports russian-type characters, and runs on mysql?.
If i am helpful, please give me reputation points.
•
•
Join Date: Jan 2009
Posts: 1,311
Reputation:
Solved Threads: 161
0
#4 17 Days Ago
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)
Failure is not an option It's included free
If at first you dont succeed, join the club
Of course its always in the last place you look, you dont keep looking after you find it
Please mark solved problems, solved
If at first you dont succeed, join the club
Of course its always in the last place you look, you dont keep looking after you find it
Please mark solved problems, solved
•
•
Join Date: May 2007
Posts: 424
Reputation:
Solved Threads: 53
Posting Pro in Training
1
#5 15 Days Ago
•
•
•
•
Originally Posted by Venom Rush 
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)
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.
Please do not ask for help in a PM. Use the forums.
And use [code] tags!
And use [code] tags!
•
•
Join Date: Oct 2007
Posts: 260
Reputation:
Solved Threads: 2
Posting Whiz in Training
0
#6 14 Days Ago
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.
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.
This user has a spatula. We don't know why, but we are afraid.
•
•
Join Date: Oct 2007
Posts: 260
Reputation:
Solved Threads: 2
Posting Whiz in Training
0
#7 14 Days Ago
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.
Thanks again to all of you that posted.
This user has a spatula. We don't know why, but we are afraid.
 |
Similar Threads
- Probably a character set problem, trying to substitute characters (Python)
- PHP Special character Problem (PHP)
- Page/Character Encoding Tips (PHP)
- force a page character set (PHP)
- Character Set Issue with RSS Feed (HTML and CSS)
- Character Set (Oracle)
- Character sets (XML, XSLT and XPATH)
- Special Character generation (Java)
Other Threads in the MySQL Forum
- Previous Thread: problem with wamp
- Next Thread: how to get back my database with damaged wamp server??
| Thread Tools | Search this Thread |
You need to join our community in order to build your list of favorite forums. You can visit the forum index for a listing of all forums.
Related Forum Features
Latest MySQL Posts
- Today's Posts
- Unanswered Threads
agplv3 alfresco amazon api artisticlicense aws bizspark camparingtocolumns changingprices cmg communityjournalism contentmanagement contractors copyright count court crm data database design developer development distinct drupal dui ec2 email enterprise eudora facebook form foss gartner gnu government gpl greenit groklaw groupware hiring hyperic images innerjoins insert ip joebrockmeier join journalism keyword kickfire laptop legal license licensing linux maintenance mariadb matchingcolumns metron micromanage microsoft microsoftexchange mindtouch montywidenius mozilla multiple music mysql mysqlcolumnupdating mysqldatetimeordermax() mysqlindex mysqlinternalqueries mysqlquery mysqlsearch news open-xchange opendatabasealliance opengovernment opensource oracle penelope php priceupdating query referencedesign reorderingcolumns saas select sharepoint simpledb single sourcecode spotify sql sugarcrm syntax table techsupport thunderbird virtualization
