Re: SELECT ' ä'='\\' gives 1

2003-02-20 Thread richardb
cc: [EMAIL PROTECTED], (bcc: BORNAY Richard/Engr/STATS/ST Group)

Re: SELECT 'ä'='\\' gives 1

2003-02-20 Thread Christian Mattick
Seems to be only a problem when I send the statement to mysql over php. If I enter the statement with the command line tool everything is fine. So this is not a mysql problem. At 15:58 20.02.2003 +0100, Stefan Hinz wrote: Christian, > SELECT 'ä' = '\\'; > gives 1 as

Re: SELECT 'ä'='\\' gives 1

2003-02-20 Thread Stefan Hinz
Christian, > SELECT 'ä' = '\\'; > gives 1 as result! Not on my server, and with my character set (latin1_de): mysql> STATUS -- mysql Ver 12.18 Distrib 4.0.10-gamma, for Win95/Win98 (i32) Connection id: 6 Current database: menagerie Curr

Re: SELECT 'ä'='\\' gives 1

2003-02-20 Thread 1LT John W. Holmes
> why does Mysql consider an 'ä' as equal to '\' ??? > The query > SELECT 'ä' = '\\'; > gives 1 as result! I get zero on 3.23.52-max-nt mysql> select 'ä' = '\\'; ++ | 'ä' = '

SELECT 'ä'='\\' gives 1

2003-02-20 Thread Christian Mattick
Hi, why does Mysql consider an 'ä' as equal to '\' ??? The query SELECT 'ä' = '\\'; gives 1 as result! Is this a bug ? Greetings, Christian - Before posting, please check: http: