Information about character lost from MySQL to Access

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
 
J

John Nurick

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?
 
I

Ivan

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
 
J

John Nurick

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with Import or Linked Tables with MySql 1
Open MySQL ODBC Connection... 2
How to link Access to MySQL 1
ODBC link to MySQL, can write, but not edit or delete 5
Access 2000/2002 to MySQL link v_e_r_y s_l_o_w 4
Access for MySQL data reports only 5
Access 2007 does not show existing data when opening form with linkedtable 8
VBA Code to Connect and Query a MySQL Table 12

Top