Pantek Library
Hosting Provided By
CybrHost
High Speed Hosting

Storing Devnagari unicode data in MySQL

From: C K <shreeseva.it(at)gmail.com>
Date: Fri Sep 28 2007 - 13:54:39 EDT


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 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.
Received on Fri Sep 28 13:55:36 2007

This archive was generated by hypermail 2.1.8 : Sun Oct 07 2007 - 10:12:43 EDT


Contact Us  Legal Notices  Order Services Online 
Pantek Home  Privacy Policy  IT news  Site Map  Pantek Library