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
