(reading some old mail) Hi Jose, don't know if folks have answered your question. If you're using Mysql 5.0 or higher, you want to check out the NO_ZERO_IN_DATE and NO_ZERO_DATE SQL modes -- http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html. Previous versions do not allow that.
For case sensitivity, see http://dev.mysql.com/doc/refman/4.1/en/case-sensitivity.html -Sheeri On 12/21/05, Jose Soares <[EMAIL PROTECTED]> wrote: > 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] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
