Re: upper function for chinese issue

Dear Sir,

When I use mysql to maintain my chinese data, I found some bug=
 for upper function:

mysql> select UPPER('=C2=F3');
+-------------+
| UPPER('=C2=F3') |
+-------------+
| =C2=D3          |        <<error
+-------------+
1 row in set (0.00 sec)

mysql> select * from sys_synonym where =
 locate(upper('=C2=F3'),upper(word))>0;
+-------+----------+
| id    | word     |
+-------+----------+
|    10 | =B9=E2=D3=B0=BA=CF=B3=C9 |       << error
|   358 | =C2=F3       |
|   512 | =B5=A4=C2=F3     |
|   878 | =B9=E2=D3=B0     |       << error
|   358 | =C2=F3=D7=D3     |
|   358 | =D0=A1=C2=F3     |
|   750 | =CF=C2=D3=EA     |       << error
|   988 | =D5=C2=D3=E3     |
| 14143 | =C2=F3=BF=CB=B7=E7   |
| 14016 | =B9=C8=C2=F3=BC=D3=B9=A4 |
| 12304 | =C2=F3=CC=EF     |
+-------+----------+
11 rows in set (0.02 sec)

mysql> select * from sys_synonym where word like '=C2=F3';
+-------+----------+
| id    | word     |
+-------+----------+
|    10 | =B9=E2=D3=B0=BA=CF=B3=C9 |       << error
|   358 | =C2=F3       |
|   512 | =B5=A4=C2=F3     |
|   878 | =B9=E2=D3=B0     |       << error
|   358 | =C2=F3=D7=D3     |
|   358 | =D0=A1=C2=F3     |
|   750 | =CF=C2=D3=EA     |       << error
|   988 | =D5=C2=D3=E3     |
| 14143 | =C2=F3=BF=CB=B7=E7   |
| 14016 | =B9=C8=C2=F3=BC=D3=B9=A4 |
| 12304 | =C2=F3=CC=EF     |
+-------+----------+
11 rows in set (0.02 sec)

if you can not read the chinse chars on your machine , pls view=
 the attached image.

thanks!

Br, 
Jimmy zhou


What charset are you using ???

What version of MySQL are you using ??

Can you try 4.1 which has better support for Chinese ?? 

-- 

Regards,

--
For technical support contracts, go to https://order.mysql.com/?ref=msmi
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Mr. Sinisa Milivojevic <[email protected]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB
/_/  /_/\_, /___/\___\_\___/   Fulltime Developer and Support Coordinator
       <___/   www.mysql.com   Larnaca, Cyprus


-- 
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe:    http://lists.mysql.com/[email protected]