Solved

How do I store Japanese characters in a mySQL database?

Posted on 2011-03-21
2
390 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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Best database setup for image uploads 6 52
simple mysql statement 3 32
Whether to use true/false, yes/no or 0/1 11 51
ebay table structure 2 14
Introduction Since I wrote the original article about Handling Date and Time in PHP and MySQL (http://www.experts-exchange.com/articles/201/Handling-Date-and-Time-in-PHP-and-MySQL.html) several years ago, it seemed like now was a good time to updat…
Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

895 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now