Re: UTF-8
Dennis Yu <[email protected]>
| Newsgroups | gmane.comp.db.mysql.odbc |
|---|---|
| Message-ID | <[email protected]> |
I'm afraid the problem end is in MS Access, if you need to use it, then may be inevitably you must face it. Long ago in DOS age, these's a Chinese environment software called Eten, may be your coworker knows it, since that time Chinese characters are represented by DBCS, mostly BIG5. I learned from that time - just use binary ASCII code, MS will assemble them to form proper Chinese characters. By the way, the reason I use MyODBC 3.51.12 is my VFP9 application was developed at that time, I compared data type returned by SELECT carefully between MySQL and VFP9 dbf. When MyODBC evolution to .14 or .15 or .16 later, I found data type returned is different from .12, and I'm tired to make other comparison, so just un-installed new version and re-installed MyODBC 3.51.12 till today. May be your diligent colleague will find other solutions. Jerry Schwartz wrote: > 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]