On May 4, 2:42*pm, "Adax" <Adax_WYTNI...@onet.pl> wrote:
> U¿ytkownik "Rik Wasmus" <luiheidsgoe...@hotmail.com> napisa³ w wiadomo¶cinewsp.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