Solved

How do I store Japanese characters in a mySQL database?

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

Hi, I will be creating today a basic tutorial on how we can create a Mail Custom Function and use it where ever we want. The main advantage about creating a custom function is that we can accommodate a range of arguments to pass to the Function and …
PROBLEM: How to add your own buttons to the bottom toolbar with paging info ( result count ). While creating a cfgrid, I ran into an issue where I wanted to embed my own custom buttons where the default ones ( insert / delete / etc… ) are for aes…
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…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

770 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