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