Access - mySQL

#1

Hello, I have problem with connection from MS Access to mySQL. In Access I
have connected tables to mySQL. In all tables strings columns have charset
UTF8. In mySQL I can see "ê ó ¼ ¿ ¶ æ...." Unfortunately, in linked
tables in Access instead of special letters I see question marks: "?"

For instance: waê -> wa? wêo¼aaa -> w?o?aaa
What could I do to repair this problem? Thank You

#2

On Sun, 04 May 2008 12:53:38 +0200, Adax <Adax_WYTNIJTO (AT) onet (DOT) pl> wrote:

Quote:

Hello, I have problem with connection from MS Access to mySQL. In
Access I have connected tables to mySQL. In all tables strings columns
have charset UTF8. In mySQL I can see "Ä™ Ã³ Åº Å¼ Å› Ä‡...."
Unfortunately, in linked tables in Access instead of special letters I
see question marks: "?"

For instance: waÄ™ -> wa? wÄ™oÅºaaa -> w?o?aaa
What could I do to repair this problem? Thank You

How do you connect Access to MySQL? ODBC? If so, what character set is
configured for this connection.
--
Rik Wasmus

#3

UÅ¼ytkownik "Rik Wasmus" <luiheidsgoeroe (AT) hotmail (DOT) com> napisaÅ‚ w wiadomoÅ›ci
news

p.uamoakhp5bnjuv (AT) metallium (DOT) lan...

Quote:

On Sun, 04 May 2008 12:53:38 +0200, Adax <Adax_WYTNIJTO (AT) onet (DOT) pl> wrote:
Hello, I have problem with connection from MS Access to mySQL. In
Access I have connected tables to mySQL. In all tables strings columns
have charset UTF8. In mySQL I can see "Ä™ Ã³ Åº Å¼ Å› Ä‡...."
Unfortunately, in linked tables in Access instead of special letters I
see question marks: "?"
For instance: waÄ™ -> wa? wÄ™oÅºaaa -> w?o?aaa
What could I do to repair this problem? Thank You
How do you connect Access to MySQL? ODBC? If so, what character set is
configured for this connection.

Thanks! Yes it's ODBC. I use mysql-connector-odbc-3.51.25-win32.ms, but
I don't know how to set character for this connection

A lot of reading
and I see that MS Access probaly has cp-1250 Please, could You help me?

http://dev.mysql.com/doc/refman/5.0/...th-access.html
25.1.5.4.3. Using Microsoft Access as a Front-end to MySQLi

#4

On May 4, 2:42*pm, "Adax" <Adax_WYTNI... (AT) onet (DOT) pl> wrote:

Quote:

U¿ytkownik "Rik Wasmus" <luiheidsgoe... (AT) hotmail (DOT) com> napisa³ w wiadomo¶cinews

p.uamoakhp5bnjuv (AT) metallium (DOT) lan...

On Sun, 04 May 2008 12:53:38 +0200, Adax <Adax_WYTNI... (AT) onet (DOT) pl> wrote:
Hello, I have problem with connection *from *MS Access to mySQL. In
Access I have connected tables to mySQL. In all tables strings columns
have charset UTF8. In mySQL I can see "ê *ó *¼ *¿ ¶ æ....."
Unfortunately, in linked tables in Access instead of special letters I
see question marks: "?"
For instance: * waê -> wa? * *wêo¼aaa -> w?o?aaa
What could I do to repair this problem? Thank You
How do you connect Access to MySQL? ODBC? If so, what character set is
configured for this connection.

Thanks! *Yes it's ODBC. * I use *mysql-connector-odbc-3.51.25-win32.ms, *but
I don't know how to set *character for this connection

* A lot of reading
and I see that MS Access probaly has cp-1250 Please, could You help me?

http://dev.mysql.com/doc/refman/5.0/...tools-with-acc...
25.1.5.4.3. Using Microsoft Access as a Front-end to MySQLi

Are you sure the data is corrupted in mysql. I've made the experience
that phpmyadmin very often shows a diffrent charset thaan is in the
db. Have you checked from a terminal with commandline sql?

cp1250 can usually be stored as latin1 or utf8 given necessary
conversion beforehand

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Access - mySQL

comp.databases.mysql comp.databases.mysql

Access - mySQL - 05-04-2008 , 05:53 AM

Re: Access - mySQL - 05-04-2008 , 06:45 AM

Re: Access - mySQL - 05-04-2008 , 07:42 AM

Re: Access - mySQL - 05-05-2008 , 04:08 PM