11 messages in com.mysql.lists.bugsFw: Error in big5 encoding, windows, ...
FromSent OnAttachments
ctl...@apricot.com.hk26 Dec 2000 20:14 
ctl...@apricot.com.hk26 Dec 2000 20:17 
ctl...@apricot.com.hk26 Dec 2000 20:23 
Matt Wagner26 Dec 2000 21:41 
Michael Widenius27 Dec 2000 01:37 
ctl...@apricot.com.hk27 Dec 2000 18:14 
Michael Widenius28 Dec 2000 04:36 
take...@SoftAgency.co.jp28 Dec 2000 04:42 
Miguel Angel Solórzano28 Dec 2000 06:46 
ctl...@apricot.com.hk28 Dec 2000 18:06 
Michael Widenius29 Dec 2000 02:03 
Subject:Fw: Error in big5 encoding, windows, all version
From:ctl...@apricot.com.hk (ctl@orionpos.com)
Date:12/26/2000 08:23:37 PM
List:com.mysql.lists.bugs

(sorry for sending serveral mails, but I find that I can't send attachment, I put the attachment file in the following link http://202.181.242.131/~ctlam/big5.jpg thank you ) Hi, Refer to the last mail, I dumped a screen that errors occur as the attachment. Although the OS is chinese windows 2000, I have test these under win NT and 98 and received the same result. In the first query , I added a space after the chinese character '蓋' and the result cannot be showed correctly (just showing a question mark). In the second query , I tried with no space after the chinese character '蓋'. Even worst, it give message like missing ' or ". The third query is a normal query and work normal.

In short, some chinese character is not accepted by mysql (not just this one), may the character include ', or " in the binary code. I have tried many times and cannot solve this problem. Hope you can help me, thank you.

---------- Forwarded message ---------- Date: Wed, 20 Dec 2000 12:33:27 +0200 (EET) From: Michael Widenius <mon@mysql.com> To: "ctl@apricot.com.hk" <ctl@orionpos.com> Cc: Thimble Smith <ti@mysql.com>, bu@lists.mysql.com Subject: Re: Error in big5 encoding, windows, all version

Hi!

"ctlam@apricot" == ctlam@apricot com hk <ctl@orionpos.com>

writes:

ctlam@apricot> Hi, ctlam@apricot> Refer to the last e-mail, ctlam@apricot> I think I should say I could store some BIG5

character

by INSERT. I

ctlam@apricot> cannot retrieve the stored characters (just a very

few

set

of characters, I

ctlam@apricot> just discovered 2 characters) by SELECT in both my program, MYSQL.exe , ctlam@apricot> through ODBC or JDBC. ctlam@apricot> I am using JDBC to connect to MYSQL. I am

wondering

whether this is

ctlam@apricot> encoding setting or anything else. ctlam@apricot> Even I type "SELECT '??;" in the MYSQL.exe command-line environment I ctlam@apricot> cannot get the correct result. ctlam@apricot> Thank you for your help.

The above select should be binary transparent and should work!

What response do you get from the client? Can you show a cut an past for this?

Here is a cut and past from linux that proves this:

mysql> SELECT '??; +-----+ | ??| +-----+ | ??| +-----+ 1 row in set (0.01 sec)

mysql> SELECT ascii(mid('??,2,1)); +-----------------------+ | ascii(mid('??,2,1)) | +-----------------------+ | 147 | +-----------------------+ 1 row in set (0.01 sec)

mysql> SELECT ascii(mid('??,3,1)); +-----------------------+ | ascii(mid('??,3,1)) | +-----------------------+ | 139 | +-----------------------+ 1 row in set (0.00 sec)

Regards, Monty

---------------------------------------------------------------------

Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before posting. To request this thread, e-mail bugs@lists.mysql.com

To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail bugs@lists.mysql.com instead.