MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:sheeri kritzer Date:January 9 2006 5:21pm
Subject:Re: autocasting
View as plain text  
(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 <jo@stripped> 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/mysql?unsub=1
>
>
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