Complementary to what Donna said,
You can issue a
SHOW WARNINGS
sql after some of these queries... the "cutt-off" will be listed there !
You will get a mysql_result in the form:
Level - Code - Message
Warning - 1265 - Data truncated for column 'column_name' at row X.
Gabriel PREDA
On 1/5/07,
l Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
> -Original Message-
> From: Olaf Stein [mailto:[EMAIL PROTECTED]
> Sent: Friday, January 05, 2007 2:26 PM
> To: Jerry Schwartz
> Subject: Re: Varchar limit warning - simila
06032
860.674.8796 / FAX: 860.674.8341
> -Original Message-
> From: Olaf Stein [mailto:[EMAIL PROTECTED]
> Sent: Friday, January 05, 2007 1:52 PM
> To: [EMAIL PROTECTED]
> Cc: MySql
> Subject: Re: Varchar limit warning - similar question
>
> Thanks
> That works nicely
Sorry, wrong example
For instance, it makes no difference regarding the values I can enter if I
declare a field as int or int(3)
On 1/5/07 1:52 PM, "Olaf Stein" <[EMAIL PROTECTED]> wrote:
> Thanks
> That works nicely.
>
> Why does that not have any effect with numeric values.
> E.g. I can inse
Thanks
That works nicely.
Why does that not have any effect with numeric values.
E.g. I can insert the same max numbers in a tinyint column then in a
tinyint(1) column,
For example, how do I create a column that only allows 1 numeric value from
0 to 5?
Thanks
Olaf
On 1/5/07 12:52 PM, "[EMAIL
You need to set the sql_mode to STRICT_TRANS_TABLES or STRICT_ALL_TABLES.
We set this for the server in the my.cnf file. Be careful, though,
because there are some third-party GUI clients that don't read the my.cnf
file and thus don't set the sql_mode to what you expect. In that case,
set it
