Re: Information about character lost from MySQL to Access

I found the solution in http://bugs.mysql.com/bug.php?id=3348 .
For my problem I have to add a string 'set names cp1250' to the Initial
Statement box of Connect Option tab of the configuration of DSN for the
Connector/ODBC driver 3.51.* as it is seen on
http://bugs.mysql.com/file.php?id=6460&text=1 .
In the Access are now in the from MySQL linked tables the right special
characters instead of questionmarks before.

Ivan



"Ivan" <ivan@xxxxxxxx> wrote in message
news:uXYxy557HHA.3716@xxxxxxxxxxxxxxxxxxxxxxx
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




.

Relevant Pages

  • Re: Information about character lost from MySQL to Access
    ... Connector/ODBC driver 3.51.* as it is seen on ... In the Access are now in the from MySQL linked tables the right special ... characters instead of questionmarks before. ...
    (microsoft.public.access.externaldata)
  • Re: [PHP] magic_quotes
    ... backslashes as if it were ASCII data, and it may *NOT* be ASCII data. ... That would lead to $_POST data like Jingle's Bells to be passed as ... You do *NOT* use stripslasheson the data coming OUT of MySQL. ... The whole point of this escaping is to identify characters that MySQL ...
    (php.general)
  • Re: [PHP] magic_quotes
    ... backslashes as if it were ASCII data, and it may *NOT* be ASCII data. ... That would lead to $_POST data like Jingle's Bells to be passed as ... You do *NOT* use stripslasheson the data coming OUT of MySQL. ... The whole point of this escaping is to identify characters that MySQL ...
    (php.general)
  • Re: Allowing special characters in a MySql Database
    ... I originally thought it was MySQL stripping them out but I did a ... actually removing the characters when i hit the submit button though. ... > php has an escape function specifically for mySQL inserts ...
    (microsoft.public.dotnet.general)