mine is getting a 0 at solaris2.7 mysql> select 'a'='\'; +----------+ | 'a'='\' | +----------+ | 0 | +----------+ 1 row in set (0.04 sec)
mysql> status -------------- mysql Ver 12.16 Distrib 4.0.9-gamma, for sun-solaris2.7 (sparc) Connection id: 159 Current database: Current user: dbadmin SSL: Not in use Current pager: stdout Using outfile: '' Server version: 4.0.9-gamma Protocol version: 10 Connection: 10.83.67.88 via TCP/IP Client characterset: latin1 Server characterset: latin1 TCP port: 3306 Uptime: 3 days 18 hours 14 min 26 sec Threads: 1 Questions: 1847 Slow queries: 16 Opens: 406 Flush tables: 9 Open tables: 3 Queries per second avg: 0.006 WHY??? Stefan Hinz <[EMAIL PROTECTED]> 20/02/2003 10:58 PM Please respond to Stefan Hinz To: Christian Mattick <[EMAIL PROTECTED]> cc: [EMAIL PROTECTED], (bcc: BORNAY Richard/Engr/STATS/ST Group) Subject: Re: SELECT 'ä'='\\' gives 1 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 Current user: superuser@localhost SSL: Not in use Server version: 4.0.10-gamma-max-nt-log Protocol version: 10 Connection: localhost via TCP/IP Client characterset: latin1_de Server characterset: latin1_de TCP port: 3306 Uptime: 1 hour 8 min 5 sec Threads: 2 Questions: 462 Slow queries: 4 Opens: 10 Flus -------------- mysql> SELECT 'ä' = '\\'; +------------+ | 'ä' = '\\' | +------------+ | 0 | +------------+ 1 row in set (0.00 sec) Regards, -- Stefan Hinz <[EMAIL PROTECTED]> iConnect GmbH <http://iConnect.de> Heesestr. 6, 12169 Berlin (Germany) Telefon: +49 30 7970948-0 Fax: +49 30 7970948-3 [filter fodder: sql, mysql, query] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php [This e-mail is confidential and may also be privileged. If you are not the intended recipient, please delete it and notify us immediately; you should not copy or use it for any purpose, nor disclose its contents to any other person. Thank you.] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php