 jayco437Premium
join:2001-08-11
Lincoln, NE | reply to squatpuke
Re: Null Vs. Empty said by squatpuke:. If a database field is originally NULL...then data is added....then removed....is the field NULL again... I would imagine it could vary between databases, but my general thought is no it would not be NULL unless you explicitly set it to NULL, versus setting it to a blank string.
said by squatpuke:. What is the difference between NULL and Once Filled/Now Empty.... NULL is usually a default value for a field that doesn't require a value. Depending on the database, you could set default to an empty string instead of NULL. You could also programmatically set a field to NULL when it has been emptied of data, thus eliminating the ambiguity between NULL and and an empty string. |
