Re: UTF-8

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:service@dennisyu.idv.tw]
>> Sent: Friday, June 29, 2007 2:04 AM
>> To: Jerry Schwartz
>> Cc: myodbc@lists.mysql.com
>> 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.
Do you need help?
In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software:
Learn more about Pantek's Technical Support offerings
Place an order for 24/7/365 Technical Support here
Learn more about Pantek, who we are, and what we do
Chat with a Live Operator
Related lists.mysql.com Links
announce
benchmarks
bugs
certification
cluster
commits
dotnet
gui-tools
internals
java
maxdb
myodbc
mysql
mysqldoc
packagers
perl
plusplus
replication
win32
Request more information about Pantek
>>>
>>> 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/myodbc?unsub=jerry@gii.co.jp
>>
>>

-- 
MySQL ODBC Mailing List
For list archives: 
http://lists.mysql.com/myodbc
To unsubscribe:    
http://lists.mysql.com/myodbc?unsub=lists@pantek.com