Chinese characters not displaying via Access
Posted by: Siew Cheng Lim
Date: January 10, 2006 09:48AM

Hi,

I've just managed to 'migrate' a number of Access tables to MySQL using Access2MySQL.
One of the fields [cname] contain Chinese characters and Access2MySQL was the only tool (I've tried others, not Navicat though) that could manage to move the chinese characters over.

show create table >>
CREATE TABLE `pbmember` (
`member_id` char(11) NOT NULL,
`ename` char(40) default NULL,
`cname` char(40) default NULL,
<a bunch of other fields>
) ENGINE=InnoDB DEFAULT CHARSET=utf8

The chinese characters are viewed correctly using MySQL Query Browser.
However, when I create a linked table to the MySQL table in Access (forms, reports are developed using Access as frontend), issuing a query to the same tables gives me 'weird characters' in the [cname] field.

I've also made sure 'SET NAMES UTF8' is in the ODBC configuration.

Anyone else got any ideas on this ?
Thanks for any help on this !

MySQL version : 5.0
Windows XP
ODBC version : 3.51.12

Regards
LSc

Options: ReplyQuote


Subject
Views
Written By
Posted
Chinese characters not displaying via Access
3267
January 10, 2006 09:48AM


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.