Access - mySQL

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

On Sun, 04 May 2008 12:53:38 +0200, Adax <Adax_WYTNIJTO@onet.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.
--
Rik Wasmus

Użytkownik "Rik Wasmus" <luiheidsgoeroe@hotmail.com> napisał w wiadomości
news:op.uamoakhp5bnjuv@metallium.lan...
> On Sun, 04 May 2008 12:53:38 +0200, Adax <Adax_WYTNIJTO@onet.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

On May 4, 2:42*pm, "Adax" <Adax_WYTNI...@onet.pl> wrote:
> U¿ytkownik "Rik Wasmus" <luiheidsgoe...@hotmail.com> napisa³ w wiadomo¶cinews:op.uamoakhp5bnjuv@metallium.lan...
>
> > On Sun, 04 May 2008 12:53:38 +0200, Adax <Adax_WYTNI...@onet.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