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
ode here.
>>
>> http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html
>>
>> Donna
>>
>>
>> Olaf Stein <[EMAIL PROTECTED]> 01/05/2007 12:37 PM
>> To
>> MySql
>> cc
>> Subject
>> Varchar limit warning
>>
c/refman/5.0/en/server-sql-mode.html
>
> Donna
>
>
> Olaf Stein <[EMAIL PROTECTED]> 01/05/2007 12:37 PM
> To
> MySql
> cc
> Subject
> Varchar limit warning
>
>
>
>
> Hi all
>
> If I insert a value to great for a field (e.g. '123
case,
set it yourself in the client:
set SESSION sql_mode='STRICT_TRANS_TABLES';
select @@session.sql_mode;
You can read about sql_mode here.
http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html
Donna
Olaf Stein <[EMAIL PROTECTED]>
01/05/2007 12:37 PM
To
MySql
Hi all
If I insert a value to great for a field (e.g. '123456' into a varchar(5)
field), mysql runs the insert without warning or error and cuts of what
doesn't fit.
How can I tell it to launch an error and abort the insert?
Thanks
Olaf
--
MySQL General Mailing List
For list archives: http://
