|Subject||RE: [firebird-support] Varchar - NULL vs blank|
> NULL means "unknown" while '' means empty.I understand that part. This is a raw data feed from a third party
where NULL is never sent, so an empty field from them does double duty.
In this case I really need to know if there is a difference in the
[mailto:email@example.com] On Behalf Of Martijn Tonies
Sent: Wednesday, October 18, 2006 12:54 PM
Subject: Re: [firebird-support] Varchar - NULL vs blank
> Is there any space savings when storing a VARCHAR as NULL vs. blank?NULL is different from ''. NULL means "unknown" while '' means empty.
> Our raw data feed is going to double in the next month, and I'm
> looking for any savings I can get.
Keep the two apart, don't worry about savings (if any).
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB,
Oracle & MS SQL Server Upscene Productions http://www.upscene.com My
Database development questions? Check the forum!
Visit http://www.firebirdsql.org and click the Resources item on the
main (top) menu. Try Knowledgebase and FAQ links !
Also search the knowledgebases at http://www.ibphoenix.com
Yahoo! Groups Links