[Linux-Biella] [php] Variabili e liste dinamiche

[vallini.daniele a bilug.linux.it]

Wed, Aug 04, 2010 at 05:30:10PM +0200  Cristiano Deana ha scritto: 

> 2010/8/4  <vallini.daniele a bilug.linux.it>:
> 
> > Le query di mysql mi pare non siano case sensitive.
> 
> Assolutamente si, a meno di utilizzare il "LIKE" al posto del "=".
> Sarebbe piuttosto sconcertante se non fosse case sensitive. ;)

Direi di no:

dan a due:~$ mysql gp
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 743
Server version: 5.0.51a-24+lenny3 (Debian)

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> select * from valazi where nome='fiat' and data='100804';
+------+------------+---------+--------+---------+---------+---------+--------+-----------+-------+
| nome | data       | apert   | min    | max     | rifer   | uff     | varuff | cval      | ret   |
+------+------------+---------+--------+---------+---------+---------+--------+-----------+-------+
| Fiat | 2010-08-04 | 10.1900 | 9.9850 | 10.2600 | 10.1000 | 10.1140 |   0.21 | 174087.00 | 1.000 | 
+------+------------+---------+--------+---------+---------+---------+--------+-----------+-------+
1 row in set (0.00 sec)

mysql> select * from valazi where nome='Fiat' and data='100804';
+------+------------+---------+--------+---------+---------+---------+--------+-----------+-------+
| nome | data       | apert   | min    | max     | rifer   | uff     | varuff | cval      | ret   |
+------+------------+---------+--------+---------+---------+---------+--------+-----------+-------+
| Fiat | 2010-08-04 | 10.1900 | 9.9850 | 10.2600 | 10.1000 | 10.1140 |   0.21 | 174087.00 | 1.000 | 
+------+------------+---------+--------+---------+---------+---------+--------+-----------+-------+
1 row in set (0.00 sec)

mysql> select * from valazi where nome='FIAT' and data='100804';
+------+------------+---------+--------+---------+---------+---------+--------+-----------+-------+
| nome | data       | apert   | min    | max     | rifer   | uff     | varuff | cval      | ret   |
+------+------------+---------+--------+---------+---------+---------+--------+-----------+-------+
| Fiat | 2010-08-04 | 10.1900 | 9.9850 | 10.2600 | 10.1000 | 10.1140 |   0.21 | 174087.00 | 1.000 | 
+------+------------+---------+--------+---------+---------+---------+--------+-----------+-------+
1 row in set (0.00 sec)

mysql> 


In sqlite3 invece la query e' case sensitive ed a me viene scomodo a dire il vero.