How is NULL stored?
| From: | Peter Lovatt | Date: | Mon, 11 Feb 2002 09:28:18 +0000 |
| Subject: | How is NULL stored? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-16787@lists.php.net to get a copy of this message | ||
Hi
When I use phpMyAdmin to view data, where values are NULL it displays the
word 'NULL'. Does this mean that the word 'NULL' is actually stored in the
table, or is it defined by some other character? Is this any different from
an empty value?
I am using it to check to see whether a value has been entered into a field,
and if so what is the value. Will MySql return an empty string or do I need
to trap for 'NULL' as well?
Ta
Peter
-----------------------------------------------
Excellence in internet and open source software
-----------------------------------------------
Sunmaia
www.sunmaia.net
info@sunmaia.net
tel. 0121-242-1473
-----------------------------------------------