myODBC / MS Access Problem with regionals chars as ľščťžýáíéúäôň

[Janko Leska]

Hi All,
I need to get someone in my home setup with a link to mySQL from Microsoft Access.
The client machine is a Windows XP running, Office XP. I've installed the latest version of MDAC (2.8) along with myODBC 3.51.12. The mySQL server is version 4.1.15-nt and is running on same machine.
I've problem with our regional language character as ľščťžýáíéúäôň. When I created in MyAdmin a table with varchar 70 type column (VARCHAR( 70 ) CHARACTER SET latin2 COLLATE latin2_general_ci ) and I insert row with chars "ľščťžýáíéúäôň". In MyAdmin I get the same string and in other PHP script I get same too, but in Access I get something like this "?š??žýáíéúäô?". Have someone idea?
I try many combinations with column type and characters set and latin2 is beter, but not good in Access. In Access I want to use the tables from mySQL as linked tables and then I want to make some reports. I want to use Access because have a frendly user GUI for reports.

I try to make configuration on C:\my.cnf

#This File was made using the WinMySQLAdmin 1.4 Tool
#23. 9. 2004 18:45:37

#Uncomment or Add only the keys that you know how works.
#Read the MySQL Manual for instructions

[mysqld]
basedir=c:/DevProgs/Mysql
#bind-address=169.254.5.202
datadir=c:/DevProgs/Mysql/data
language=c:/DevProgs/Mysql/share/slovak
#slow query log#=
#tmpdir#=
#port=3306
#set-variable=key_buffer=16M
[WinMySQLadmin]
Server=c:/DevProgs/Mysql/bin/mysqld-nt.exe
character-sets-dir=C:/DevProgs/Mysql/share/charsets/
#default-character-set=slovak

#character_set_connection=utf8
#character_set_results=utf8
#character_set_client=utf8
#default-character-set=utf8
#character-set-server=utf8
#collation-server=utf8_general_ci

default-character-set = utf8
character-set-server = utf8
collation-server = utf8_general_ci

#character_set_client = cp1250
#character_set_connection = cp1250
#character_set_results = cp1250
#collation_connection = cp1250_general_ci

character_set_client = latin2
character_set_connection = latin2
character_set_results = latin2
collation_connection = latin2_general_ci

#character_set_client = utf8
#character_set_connection = utf8
#character_set_results = utf8
#collation_connection = utf8_general_ci

Thanks all