|
|
Posted by "Richard Lynch" on 10/18/05 21:49
On Tue, October 18, 2005 12:42 pm, tg-php@gryffyndevelopment.com wrote:
> That should work. You can set it so you can't have NULL, but dont
> know of anything that tells the database not to accept '' as a value
Any database, other than MySQL, is *NOT* going to accept '' as an
integer value.
Because '' is not an integer by any stretch of the imagination.
If you don't care about ever porting your application to something
other than MySQL, then you can IGNORE the advice to not use '' on
integers.
If there's ANY possibility that some day somebody might maybe wanna
use a different database with your application, then don't confuse
strings with integers.
Actually, it might be better for your own
education/sanity/comprehension/documentation/code to not confuse
strings and integers with '' around integers in the SQL, but if
everything ELSE is good in your code, and it's "always going to be
MySQL" then it's fine.
Note that:
$value2 = 'NULL'; //PHP $value2 is a string
$query = "insert into (integer_field) values ($value2)";
//PHP $query is a string, but...
The place-holder in $value2 will be just: NULL
No quotes.
No apostrophes.
Not a string.
NULL
SQL NULL value representing "no value"
--
Like Music?
http://l-i-e.com/artists.htm
Navigation:
[Reply to this message]
|