Can't send unicode via ODBC connection
Posted by: Colin Bannister
Date: February 07, 2006 04:17AM

I've setup MySQL 5.0 on a linux box, and have set default character set to be
UTF8. I can use MySQL query browser to examine, and input, data, which is displayed OK
on a web browser, using PHP.

What I cannot do, but would like to, is to use Access as a front end, and import data
using an ODBC connection. I have MySQL ODBC driver 3.51 installed, but when I do a transfer, the data reverts to single byte characters, and I lose the unicode.

So I have to face exporting my data from Access, and creating sql files to input to
Query browser - UNLESS someone on this forum has solved this problem ?

Most grateful for any assistance!

Colin Bannister

University of Nottingham, England.

Options: ReplyQuote

Written By
Can't send unicode via ODBC connection
February 07, 2006 04:17AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.