Author Topic: Storing Foreign Characters ( chinese, arabic, etc )  (Read 1125 times)

0 Members and 1 Guest are viewing this topic.

Offline mattkenefickTopic starter

  • Irregular
  • Posts: 25
    • View Profile
Storing Foreign Characters ( chinese, arabic, etc )
« on: February 27, 2008, 09:46:35 AM »
I have a table setup in MySQL to contain different copy versions of this page. It's collation is "utf8_general_ci" and the type is "text". Will this be able to store Chinese Simplified/Traditional, Arabic, etc characters?

Not necessarily for Americans to view, but for their own country's viewing. So if I was in China, wrote on the Chinese keyboard and stored it.. Then refreshed my screen, I'd be able to see it? or would the Collation mess it all up?

Thanks a ton!
And this is very very urgent. Sorry :(

Offline fenway

  • MySQL Si-Fu / PHP Resident Alien
  • Global Moderator
  • 'Mind Boggling!'
  • *
  • Posts: 15,444
  • Gender: Male
    • View Profile
Re: Storing Foreign Characters ( chinese, arabic, etc )
« Reply #1 on: February 27, 2008, 11:59:56 AM »
UTF-8 can store anything... just make sure that your editor / server-side script / etc. know about this too.
:anim_rules: Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.