Mailing List
Home
Forum Home
MySQL General - General MySQL discussion
MySQL++ - Programming with the C++ API to MySQL
MaxDB - Everything about MaxDB, formerly known as SAP DB
ODBC - ODBC with the MySQL Connector/ODBC driver
MySQL on Win32 - Runing MySQL on Windows 9x/Me/NT/2000/XP
Java Help - Mostly related to the MySQL Connector/J driver
Perl - Perl support for MySQL with DBI and DBD::mysql
GUI - MySQL GUI Tools
Announcement
Subjects
• Subject: mysql openssl Question
• ERROR 1045: Access denied for user: 'root@localhost ' (Using
password: NO)
• Update one field with more fields from another table
• Subject: Getting Identity after INSERT
• ERROR 2002: Can 't connect to local MySQL server through socket
• mysql test 4 1 fails with the gis test
• Subject: MySQL Cluster Software
• Downgrade Mysql from 4 to 3 23
• Mysql 4 0 Oracle Stored Procedure Trigger Conversion
• Can 't access mysql after kernel upgrade
• Executing MySQL Commands From Within C Program
• Comparing and writing out BLOBS
• Subject: Re: Preventing Duplicate Entries
• FULLTEXT query format question
• Strange behavior, Table Level Permission
• Does the binary log enabling affect the MySQL performances?
• mysql:it 's a db not a dbms how it 's possible?!
• mysql have same function mthod as Oracle decode()
 
Subject: Storing Devnagari unicode data in MySQL

Subject: Storing Devnagari unicode data in MySQL

2007-09-28       - By C K

 Back
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.