Re: mysql and unicode text data - Mark Matthews - com.mysql.lists.java

3 messages in com.mysql.lists.javaRe: mysql and unicode text data

From	Sent On	Attachments
Richard Bolen	05 Aug 2002 13:06
Mark Matthews	05 Aug 2002 13:11
Kaarle Kaila	05 Aug 2002 13:23

Subject:	Re: mysql and unicode text data
From:	Mark Matthews (mmat...@thematthews.org)
Date:	08/05/2002 01:11:36 PM
List:	com.mysql.lists.java

The characters are turned into whatever characterEncoding is set to.

You will need to store them in BLOBs if you absolutely don't want them to get corrupted, but it seems that no one has had problems storing UTF-8 in normal database fields.

-Mark

----- Original Message ----- From: "Richard Bolen" <bol...@GretagMacbeth.com> To: "MySQL Java List (E-mail)" <ja...@lists.mysql.com> Sent: Monday, August 05, 2002 3:06 PM Subject: mysql and unicode text data

I saw a message on this list indicating that adding the "useUnicode=true&characterEncoding=UTF-8" to your JDBC URL enables unicode support. Is this all you have to do or do you also have to define the text fields in the database as binary?

What actually happens when unicode support is turned on? Are the unicode chars translated into ISO-8859-1 at the driver level?

If there is documentation somewhere that explains this could someone point me to it?

thanks, Rich

-------------------------------------------------------------------- Rich Bolen Senior Software Developer GretagMacbeth Advanced Technologies Center 79 T. W. Alexander Drive - Bldg. 4401 - Suite 250 PO Box 14026 Research Triangle Park, North Carolina 27709-4026 USA Phone: 919-549-7575 x239, Fax: 919-549-0421

http://www.gretagmacbeth.com/

--------------------------------------------------------------------

To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail java...@lists.mysql.com instead.