RE: [PHP-DB] mysql data truncation does not cause an error to be thrown

You may want to check the my.ini setting for the table type you are using and see if there is a setting in there that needs to be enabled. I thought I read once that truncation may happen silently depending on the my.ini setting. Just a thought. Ken Vandegrift Shari's Management Corporation Web Developer/Administrator (Direct) 503-605-4132 kvandegrift@sharis.com -----Original Message----- From: Andrew Blake [mailto:a.blake@har.mrc.ac.uk] Sent: Thursday, November 08, 2007 7:51 AM To: Instruct ICC Cc: php-db@lists.php.net Subject: Re: [PHP-DB] mysql data truncation does not cause an error to be thrown Hiya I could check the length of the field against the entry data and javascript myself out of trouble but i was more worried that there is no error or message when mysql clearly returns one saying i've truncated this yet php ignores it completely. It should fail or know about the truncation at least ! Cheers for your reply though :-) Andy Instruct ICC wrote: >> Using mysql_query if i try to force more data than a field can have the >> data is truncated yet no error is throw at all. >> Is there a way round this ? >> Cheers >> >> Andy >> > > This isn't exactly what you want to hear, but how about validating your input before submitting a query? > > _________________________________________________________________ > Boo! Scare away worms, viruses and so much more! Try Windows Live OneCare! > http://onecare.live.com/standard/en-us/purchase/trial.aspx?s_cid=wl_hotm ailnews > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php