Hi all,
I have some troubles about autocasting and unsensitive case.
Look at this:
mysql> select data_fattura from 2005_ordini where data_fattura = 99999911;
| 0000-00-00 |
| 0000-00-00 |
| 0000-00-00 |
| 0000-00-00 |
| 0000-00-00 |
| 0000-00-00 |
| 0000-00-00 |
| 0000-00-00 |
| 0000-00-00 |
| 0000-00-00 |
| 0000-00-00 |
+--------------+
926 rows in set (0.00 sec)
and look at this:
mysql> select data_fattura from 2005_ordini where data_fattura =
'9999-99-11';
| 0000-00-00 |
| 0000-00-00 |
| 0000-00-00 |
| 0000-00-00 |
| 0000-00-00 |
| 0000-00-00 |
| 0000-00-00 |
| 0000-00-00 |
| 0000-00-00 |
| 0000-00-00 |
| 0000-00-00 |
+--------------+
926 rows in set (0.00 sec)
mysql> select orecchio_ristampa,azienda from test;
+-------------------+----------+
| orecchio_ristampa | azienda |
+-------------------+----------+
| D | 006TS130 |
| S | 006TS130 |
| 0 | 006TS130 |
| Y | 006TS130 |
| X | 006TS130 |
| E | 006TS130 |
| 0 | 006ts130 |
+-------------------+----------+
7 rows in set (0.00 sec)
mysql> select orecchio_ristampa,azienda from test where
orecchio_ristampa=0 and azienda='006ts130';
+-------------------+----------+
| orecchio_ristampa | azienda |
+-------------------+----------+
| D | 006TS130 |
| S | 006TS130 |
| 0 | 006TS130 |
| Y | 006TS130 |
| X | 006TS130 |
| E | 006TS130 |
| 0 | 006ts130 |
+-------------------+----------+
7 rows in set (0.00 sec)
Is there a way to disable autocasting and unsensitive case?
Thank you,
j
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
