Re: Information about character lost from MySQL to Access

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
    ... Changing the font to Arial Unicode MS brings back the same situation - some ... Croatian and some other languages) from MySQL database are shown ... include glyphs for the characters in question? ... What happens if you use a font such as Arial Unicode MS or Lucida Sans ...
    (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)
  • 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)