General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Will empty string take up more space?
My app will connect to either a VFP database or a SQL server (switchable by changing an INI file). I have set the TEXT field in SQL, mapping to a MEMO field in VFP, "not nullable" and default to an empty string. I think this is a better choice over setting the TEXT field nullable and default to NULL since code for both VFP and SQL backend will be easier to be kept the same.
What I understand is a TEXT field is a pointer to actual information. May question is will defaulting a TEXT field to an empty string (real value) take up more space than defaulting it to Null (no value).
TIA
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only