Information about character lost from MySQL to Access

  • Thread starter Thread starter Ivan
  • Start date Start date
I

Ivan

Hello,

In one of my Access 2007 application I am using a linked table from a MySQL
data base. I am using the last MySQL Connector/ODBC driver ver. 3.51.18.

The cause for my difficulty is that the server of MySQL uses UTF-8 code
table, my computer but uses WIN1250 code table what exibits the appearance
of questionmarks (?) for some non english characters in the string fields of
the linked table.

What can I do? Is there any way (to set the driver ?) to get the right
character from MySQl to Access?

Ivan
 
Hi Ivan,

Could this be because the font you are using in Access does not
include glyphs for the characters in question?

What happens if you use a font such as Arial Unicode MS or Lucida Sans
Unicode which includes almost all the characters in common use
anywhere?
 
Hi John,

Changing the font to Arial Unicode MS brings back the same situation - some
special non-english characters (like C, c, C, c, which are used in
Slovenian, Croatian and some other languages) from MySQL database are shown
as questionmarks (?) in Access.

In the meantime I made a small survey on the web and it seems, that the
problem is not and it will not be solved with MySQL Connector/ODBC driver
version 3.51.* ? ( http://bugs.mysql.com/bug.php?id=27403 )

Ivan
 
Back
Top