Solved

How do I store Japanese characters in a mySQL database?

Posted on 2011-03-21
2
393 Views
Last Modified: 2012-08-14
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.
0
Comment
Question by:14_east
2 Comments
 
LVL 52

Accepted Solution

by:
_agx_ earned 250 total points
ID: 35185302
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
 

Author Comment

by:14_east
ID: 35222824
thanks man, I'll be sure to check that when I do thisnext week!
0

Featured Post

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Foreword This article was written many years ago, in the days when PHP supported the MySQL extension (http://php.net/manual/en/function.mysql-connect.php).  Today (http://php.net/manual/en/migration70.removed-exts-sapis.php) you would not use MySQL…
Sometimes databases have MILLIONS of records and we need a way to quickly query that table to return the results me need. Sure you could use CFQUERY but it takes too long when there are millions of records. That is why SOLR was invented. Please …
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question