MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:Jose Soares Date:December 21 2005 1:06pm
Subject:autocasting
View as plain text  
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



Thread
high load average with 4.1.16Christian Meisinger21 Dec
  • Re: high load average with 4.1.16Christian Meisinger21 Dec
    • Re: high load average with 4.1.16Christian Meisinger21 Dec
      • Re: high load average with 4.1.16Jørn Dahl-Stamnes21 Dec
        • Re: high load average with 4.1.16Christian Meisinger21 Dec
  • autocastingJose Soares21 Dec
    • Re: autocastingsheeri kritzer9 Jan