  | | | Subject: RE: Storing Devnagari unicode data in MySQL | Subject: RE: Storing Devnagari unicode data in MySQL 2007-09-28 - By Jerry Schwartz
Back Try upgrading to a version 5 of the ODBC connector. It worked for our Chinese data.
Regards,
Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
www.the-infoshop.com www.giiexpress.com www.etudes-marche.com
> -- --Original Message-- -- > From: C K [mailto:shreeseva.it@(protected)] > Sent: Friday, September 28, 2007 1:55 PM > To: mysql@(protected); myodbc@(protected) > Subject: Storing Devnagari unicode data in MySQL > > Namaskar, > > I am using Windows Xp SP2 and Mysql 5.0.45 and MyODBC 3.51.19 with > Microsoft > Marathi Indic IME 1 version 5. > I am storing data in both languages i.e. Marathi and English. So I > changed > database character set to 'utf8 -- UTF-8 (See http://UTF-8.ora-code.com) Unicode' and collation to > 'utf8_unicode_ci'. Also I changed the field properties charset to > 'utf8' and > collation to 'utf8_unicode_ci' for all varchar and text fields. I am > using > MS Access 2003 as a front-end. When I am entering data in Marathi I can > read > and write data in Access tables, but when I am entering data I can view > data > in Marathi but after storing it in MySQL tables, I can not read data > and > just see question marks for the characters I entered. This is not > happening > only when I am storing data using Access as a front-end, but also I > tried it > by using other mysqk GUI tools, but i get same wrong results. Can any > one > please help me. Please give the reasons behind it and the solution to > it. > Thanks for your sincere help. > > Regards, > CPK > > -- > Keep your Environment clean and green.
-- MySQL ODBC Mailing List For list archives: http://lists.mysql.com/myodbc To unsubscribe: http://lists.mysql.com/myodbc?unsub=mysql@(protected)
|
|
 |