Hi Matt,
Thanks. That did the trick.
James
-Original Message-
From: Matt W [mailto:[EMAIL PROTECTED]
Sent: Friday, September 19, 2003 11:34 PM
To: [EMAIL PROTECTED]
Subject: Re: INSERT/UPDATE number weirdness
Hi James,
Well if you used [VAR]CHAR/TEXT and then did the INSERT query
Hi James,
Well if you used [VAR]CHAR/TEXT and then did the INSERT query *with* the
leading 0s, it should work. If the 0s aren't there in PHP, they won't be
stored in the CHAR column though.
But anyway, it's more efficient to stick with SMALLINT... and use the
ZEROFILL attribute on the column. :-)
