10 messages in com.mysql.lists.javaRE: UTF-8 in MySQL?
FromSent OnAttachments
Richard Bolen12 Nov 2002 12:18 
Richard Bolen13 Nov 2002 10:22 
Evgeniy Strokin (rT)13 Nov 2002 11:33 
Jon Frisby13 Nov 2002 11:34 
Kaarle Kaila13 Nov 2002 12:51 
Jon Frisby13 Nov 2002 14:03 
Mark Matthews13 Nov 2002 14:08 
Kaarle Kaila14 Nov 2002 13:01 
Kaarle Kaila14 Nov 2002 22:56 
Kaarle Kaila19 Nov 2002 14:24 
Subject:RE: UTF-8 in MySQL?
From:Richard Bolen (bol@GretagMacbeth.com)
Date:11/13/2002 10:22:54 AM
List:com.mysql.lists.java

FYI: There is a parameter that can be set on the DB connection URL that turns Unicode support on/off (useUnicode=true|false). This appears to work. From the readme, the Unicode data is transcoded to the native character set of the database before it is inserted. I was wondering if anyone knows what subset of Unicode characters are supported? I guess it's only the single byte characters that are supported by the mysql server character set. What happens to unsupported characters? Are they dropped from the data?

Thanks, Rich

-----Original Message----- From: Richard Bolen Sent: Tuesday, November 12, 2002 3:19 PM To: ja@lists.mysql.com Subject: UTF-8 in MySQL?

I'm trying to store UTF-8 encoded XML data in mysql. I've seen a few threads here and elsewhere talking about how MySQL does not support UTF-8 yet. I've also seen messages stating that people are storing UTF-8 data successfully in mysql.

Could someone tell me how to store UTF-8 text in mysql? Is there something I can do on the java side to insure utf-8 data goes into and back out of the database unmodified?

Thanks, Rich

--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/doc/ (the manual) http://lists.mysql.com/ (the list archive)

To request this thread, e-mail <java@lists.mysql.com> To unsubscribe, e-mail <java-unsubscribe-bolen=gret@lists.mysql.com>