hi, i am migrating a legacy java application. so i am not suppose to change too much things.
the problem is that the app store in multiple language such as korean and english. if i load again the new saved data, then korean language will only be like '????????,???' old data are ok. displayed in their own language. spec : win2k, mysql 4.1.7(migrated from 4.0.12), mysql-connector-java-3.1.6 show variables like '%char%'; character_set_client | latin1 character_set_connection | latin1 character_set_database | utf8 character_set_results | latin1 character_set_server | utf8 character_set_system | utf8 this is my.ini(cleaned up) [client] port=3306 [mysqld] port=3306 default-character-set=utf8 default-storage-engine=INNODB i read the mysql doc so .. ->change my COLUMN table default encoding such as .. "alter table newsletter default character set ucs2;" but not work. i also read connector/j doc to add "characterEncoding=utf8" in my connection string. but i cannot to do that(if tried but failed). the connection is made through java reflection on properties of com.mysql.jdbc.jdbc2.optional.MySqlDAtasource. any suggestion ? thanks. __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
