Linking MySQL to Access cyrillic problem

Hi,

I installed mysql-connector-odbc-3.51.14-win32 and then I connected to
my
database. The problem occured because I have Cyrillic letters in
MySQL
database and the data I see in Access is illegible, and those signs
can't be
read or understood.

How can I solve this situation

Thanks

> I installed mysql-connector-odbc-3.51.14-win32 and then I connected to
> my
> database. The problem occured because I have Cyrillic letters in
> MySQL
> database and the data I see in Access is illegible, and those signs
> can't be
> read or understood.

Welcome to the wonderful world of encodings :(

There are two sides to this problem, off course.
In MySQL, check the encoding variables. Run a pass-through query:
SHOW VARIABLES LIKE '%char%'

If the output is not a great help, read the MySQL manual section on this:
http://dev.mysql.com/doc/refman/5.0/en/charset.html

On the Access side, there might be something in the help file on how to
set encodings or on how encodings are passed. MySQL uses identifiers for
encodings, which means that all dashes are stripped ("utf-8" is "utf8"
in MySQL)


Hope this is of any help,
--
Willem Bogaerts

Application smith
Kratz B.V.
http://www.kratz.nl/