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,