How do I store Japanese characters in a mySQL database?

I hav a client who needs a form that people will fill out with Japanese characters.  We are running Cold fusion and mySQL...

thanks in advance.
14_eastAsked:
Who is Participating?
 
_agx_Connect With a Mentor Commented:
For most languages, you just need to set the table character set to UTF8
http://dev.mysql.com/tech-resources/articles/4.1/unicode.html

Then ensure you've enabled unicode in your CF dsn
1) Select  Data & Services > Datasources > (Your MySQL Datasource)
2) Click:   Show Advanced Settings
3) In "Connection Settings" enter:
useUnicode=true&characterEncoding=UTF-8

Open in new window


Save the settings
0
 
14_eastAuthor Commented:
thanks man, I'll be sure to check that when I do thisnext week!
0
All Courses

From novice to tech pro — start learning today.