MySQL Forums
Forum List  »  Connector/ODBC

myODBC / MS Access Problem with regionals chars as ľščťžýáíéúäôň
Posted by: Janko Leska
Date: November 29, 2005 05:54PM

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

#slow query log#=


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

Options: ReplyQuote

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.