[e_sharad]

Hi we are interested in knowing how to store and retrive our multilingual data in MySQL database. Can you please give us detaild information regarding
it. Also if possible we want to know details about platform,language used
etc... _ _
In short we want unicode support in mysql.
please anyone knows send me reply as soon as possible.
Thanks in advance.
Sam

[asherh]

Originally posted by e_sharad
Hi we are interested in knowing how to store and retrive our multilingual data in MySQL database. Can you please give us detaild information regarding
it. Also if possible we want to know details about platform,language used
etc... _ _
In short we want unicode support in mysql.
please anyone knows send me reply as soon as possible.
Thanks in advance.
Sam

Hi Sam,

Place the following in your /etc/my.cnf file:


[mysqld]
default-character-set=utf8


and in your JDBC connection parameter list add:

enableUnicode="true"
characterEncoding="UTF-8"

which will ensure you can write and retrieve UTF-8 encoded characters from the database. you may want to use the latest stable release of Connector J from MySQL... I think it is 3.0.8 from memory.

That should work ok

chrs.

[asherh]

Originally posted by asherh
Hi Sam,

Place the following in your /etc/my.cnf file:


[mysqld]
default-character-set=utf8


and in your JDBC connection parameter list add:

enableUnicode="true"
characterEncoding="UTF-8"

which will ensure you can write and retrieve UTF-8 encoded characters from the database. you may want to use the latest stable release of Connector J from MySQL... I think it is 3.0.8 from memory.

That should work ok

chrs.

oh yeah, i assume you are using MySQL 4.1 Alpha. Don't think Unicode is supported before that version.