Hi!

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