List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:October 10 2002 11:27pm
Subject:Re: why char(192) = char(194) = char(193) = char(195) ?
View as plain text  
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.

Thread
why char(192) = char(194) = char(193) = char(195) ?lb9 Oct
  • Re: why char(192) = char(194) = char(193) = char(195) ?Paul DuBois11 Oct