Forums » MySQL » MySQL Discussion

Thread: Getting Chinese Characters to work.

This question is not answered. Helpful answers available: 2. Answered answers available: 1.


Permlink Replies: 1 - Pages: 1 - Last Post: Jan 28, 2013 10:56 AM by: Scott M. Sanders
Becky

Posts: 1
Registered: 1/25/13
Getting Chinese Characters to work.
Posted: Jan 25, 2013 2:40 PM
 
  Click to reply to this thread Reply

Recently we've started receiving data in Chinese and are having trouble getting it to show up properly in our Databases.

I'm generally importing CSV files from excel. But I've tried getting this to work by exporting the file from excel as unicode but that hasn't produced any results.

I've done some research but so far none of the solutions I've found work for me. I'm currently running version 6.3 of Toad. I can't get any changes in collation to save on the database level. And I've tried setting the collation to utf8 on every level that I can reach but it's still not working. Everything ends up reverting back into latin.

I've read a few places that I'd potentially need to change the collation on the server level. Which seems to only be something you can do when you create the server.

If anyone could give me some insight on what to try next I'd really appreciate it.


Scott M. Sanders


Posts: 40
Registered: 1/27/11
Re: Getting Chinese Characters to work.
Posted: Jan 28, 2013 10:56 AM   in response to: Becky
 
  Click to reply to this thread Reply

I cannot get Toad to do Chinese either.

But I can with PHP just fine.



Legend
Guru: 2001 + pts
Expert: 751 - 2000 pts
Enthusiast: 31 - 750 pts
Novice: 0 - 30 pts
Moderators
Helpful answer (5 pts)
Answered (10 pts)

Point your RSS reader here for a feed of the latest messages in all forums