DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;
[/SQL]
I understand that there are ways around this but php should really
automatically notify of the warning.
Maybe i'm missing something obvious..
Cheers
Andy
Andrew Blake wrote:
I figured it out
it was the mysql install not php :-)
cheers for your
);
$insertquery=insert into test values('012345678901234567891');
$results= mysql_query($insertquery) or die('Error, insert query failed');
print_r($results);
echo br.mysql_errno($db) . : . mysql_error($db) . br.
mysql_info($db) ;
?
Andrew Blake wrote:
Hello
It seems that the normal mysql_query
Hiya
This seems to be one thing java has over php (perl etc) as it does know
about the warning and acts approperately. This should be an option to
ignore or not ignore warnings within php to prevent errorless truncation
of data.
Cheers
Andy
chris smith wrote:
On Nov 9, 2007 8:34 PM, Andrew
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
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
happen silently depending on
the my.ini setting.
Just a thought.
Ken Vandegrift
Shari's Management Corporation
Web Developer/Administrator
(Direct) 503-605-4132
[EMAIL PROTECTED]
-Original Message-
From: Andrew Blake [mailto:[EMAIL PROTECTED]
Sent: Thursday, November 08, 2007 7:51 AM
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