RE: UTF-8

Thanks for the response. It is rather disappointing, because if I understand
you correctly then MS Access might be the problem.

One of my coworkers is using Chinese XP (I'm not sure if it is traditional
or not), and I think he has the Chinese version of MS Access. I will have to
double-check with him, and see if there is anything he can change on his end
that makes this work.

Do you have any suggestions?

Regards,

Jerry Schwartz
The Infoshop by Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032

860.674.8796 / FAX: 860.674.8341

www.the-infoshop.com
www.giiexpress.com
www.etudes-marche.com


> -----Original Message-----
> From: Dennis Yu [mailto:[email protected]]
> Sent: Friday, June 29, 2007 2:04 AM
> To: Jerry Schwartz
> Cc: [email protected]
> Subject: Re: UTF-8
>
> FYR, I use MyODBC 3.51.12 with Visual FoxPro 9 and MySQL 5.0.41 in
> Traditional Chinese Windows XP pro, tables like below example are
> working fine.  Chinese data are displayed normal in VFP aplication and
> Command Line Client, but garbage in MySQL Query Browser.
>
>
> mysql> SHOW CREATE TABLE dsleger\G
> *************************** 1. row ***************************
>        Table: dsleger
> Create Table: CREATE TABLE `dsleger` (
>   `recnbr` int(10) unsigned NOT NULL auto_increment,
>   `no` varchar(12) collate latin1_bin default NULL,
>   `code` varchar(12) collate latin1_bin default NULL,
>   `acc` varchar(20) collate latin1_bin default NULL,
>   `nbr` decimal(8,2) default NULL,
>   `price` decimal(9,2) default NULL,
>   `i_basic` char(4) collate latin1_bin default NULL,
>   `desc` varchar(52) collate latin1_bin default NULL,
>   `dc` char(1) collate latin1_bin default NULL,
>   `amount` decimal(12,2) default NULL,
>   `rmk` varchar(512) collate latin1_bin default NULL,
>   PRIMARY KEY  (`recnbr`),
>   KEY `I_no` (`no`(10)),
>   KEY `I_code` (`code`),
>   KEY `I_desc` (`desc`)
> ) ENGINE=MyISAM AUTO_INCREMENT=31528 DEFAULT CHARSET=latin1
> COLLATE=latin1_bin COMMENT='DetailSleger'
> 1 row in set (0.00 sec)
>
>
>
> Jerry Schwartz wrote:
> > Did I read somewhere that ODBC 3.x doesn't support UTF-8?
> We're trying to
> > display Chinese characters in MS Access. The characters are
> there in the
> > MySQL data base, and display just fine using our web-based
> applications, but
> > our goal is to allow our users to use MS Access for ad hoc queries.
> >
> > Currently, no matter what I've tried, all I ever see is
> garbage. Will ODBC 5
> > resolve this? Does anyone have any ideas?
> >
> > Regards,
> >
> > Jerry Schwartz
> > The Infoshop by Global Information Incorporated
> > 195 Farmington Ave.
> > Farmington, CT 06032
> >
> > 860.674.8796 / FAX: 860.674.8341
> >
> > www.the-infoshop.com <http://www.the-infoshop.com/>
> > www.giiexpress.com <http://www.giiexpress.com/>
> > www.etudes-marche.com
> >
> >
>
>
> --
> MySQL ODBC Mailing List
> For list archives: http://lists.mysql.com/myodbc
> To unsubscribe:    http://lists.mysql.com/[email protected]
>
>




-- 
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/[email protected]