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]