List:General Discussion« Previous MessageNext Message »
From:richardb Date:February 21 2003 3:08am
Subject:Re: SELECT ' ä'='\\' gives 1
View as plain text  
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 <list_hinz@stripped> 20/02/2003 10:58 PM
Please respond to Stefan Hinz
                                                                                          
                                                
              To:  Christian Mattick <cm@stripped>                               
                                                      
              cc:  mysql@stripped, (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 <hinz@stripped>
  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 <mysql-thread132946@stripped>
To unsubscribe, e-mail
<mysql-unsubscribe-richardb=stats.st.com.sg@stripped>
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.]


Thread
Re: SELECT ' ä'='\\' gives 1richardb21 Feb