At 12:18 +0800 10/9/02, lb wrote:
>Dear all,
>
>I am not sure why mysql thinks char(192) = char(194) = char(193) =
>char(195)?
Presumably they are the same according to the character set's
collating sequence.
>
>mysql> select char(192)=char(193);
>+---------------------+
>| char(192)=char(193) |
>+---------------------+
>| 1 |
>+---------------------+
>1 row in set (0.00 sec)
>mysql> select char(192)=char(194);
>+---------------------+
>| char(192)=char(194) |
>+---------------------+
>| 1 |
>+---------------------+
>1 row in set (0.01 sec)
>
>mysql> select char(192)=char(195);
>+---------------------+
>| char(192)=char(195) |
>+---------------------+
>| 1 |
>+---------------------+
>1 row in set (0.01 sec)
>
>mysql> select char(192)=char(196);
>+---------------------+
>| char(192)=char(196) |
>+---------------------+
>| 0 |
>+---------------------+
>1 row in set (0.00 sec)
>
>Oscar Yen.
