Re: Chinese and MySQL / UTF8 and versions - Esteban Ramirez - com.mysql.lists.java

7 messages in com.mysql.lists.javaRe: Chinese and MySQL / UTF8 and vers...

From	Sent On	Attachments
Neil Pitman	18 Feb 2004 02:42
Esteban Ramirez	19 Feb 2004 04:28
ho...@szakalmetal.hu	19 Feb 2004 11:31
Esteban Ramirez	20 Feb 2004 02:53
Mark Matthews	20 Feb 2004 07:01
Esteban Ramirez	20 Feb 2004 07:24
Mark Matthews	20 Feb 2004 07:45

Subject:	Re: Chinese and MySQL / UTF8 and versions
From:	Esteban Ramirez (nets...@yahoo.com.au)
Date:	02/20/2004 02:53:52 AM
List:	com.mysql.lists.java

thanks for the info but unfortunately we do not have the time or resources to
indulge in mysql development. we will wait until mysql supports additional utf8
collation options. if we run into too many multilingual problems with mysql we
have a contingency plan to move to another rdbms.

re changing c source code... even though the changes may be simple we dont want to add mysql source code to
our development cycle.

frankly, i am a little disappointed that weve had this problem, and others, as i
suspect had we chosen another rdbms like microsoft things would have been
easier. anyway weve committed ourselves for the time being.

steven

ho...@szakalmetal.hu wrote: On Thu, 19 Feb 2004, Esteban Ramirez wrote:

im using mysql 4.1.1a-alpha and mysql-connector-java-3.0.9-stable to store
korean data. however i use the euckr character set for my tables because i need
to be able to sort my data using korean collation methods. as far as i know
there is no korean collation option for utf8 data in my version of mysql. if u need to sort your data then u might have to consider something other than
utf8 unless someone else knows better.

you can easily alter utf8 sort order by modifing strings/ctype-utf8.c in the mysql-4.1 source. basic C skills are required. upper/lower case mapping is also there.

Agoston