Re: Information about character lost from MySQL to Access
- From: "Ivan" <ivan@xxxxxxxx>
- Date: Wed, 5 Sep 2007 11:23:35 +0200
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
"John Nurick" <j.mapson.nurick@xxxxxxxxxxxxxx> wrote in message
news:onfrd3h7v0fai9sgtuhlctodataopbgnbo@xxxxxxxxxx
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?
On Fri, 31 Aug 2007 14:02:47 +0200, "Ivan" <ivan@xxxxxxxx> wrote:
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
John Nurick - Access MVP
.
- Follow-Ups:
- References:
- Re: Information about character lost from MySQL to Access
- From: John Nurick
- Re: Information about character lost from MySQL to Access
- Prev by Date: Re: Problem linking to SQL tables in Access
- Next by Date: Re: Exporting Data Into Excel
- Previous by thread: Re: Information about character lost from MySQL to Access
- Next by thread: Re: Information about character lost from MySQL to Access
- Index(es):
Relevant Pages
|
