Storing Devnagari unicode data in MySQL

Storing Devnagari unicode data in MySQL

am 28.09.2007 19:54:39 von C K

------=_Part_1844_9669335.1191002079483
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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.

------=_Part_1844_9669335.1191002079483--