By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,609 Members | 2,246 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,609 IT Pros & Developers. It's quick & easy.

can space be provided as a value in the column (of database) ?

P: 6
Can we have spaces as values in the columns of database ?
If so, are they equivalent to null values ?
Sep 25 '07 #1
Share this Question
Share on Google+
1 Reply

Expert 100+
P: 297

yes, a space (' ') is valid content for a char or varchar column. Just put a space into single quotes (') when inserting. You may use it in selects/queries as "... where mycolumn=' ' ".

No, NULL means there's nothing in this field, no space (which basically is text), no number, nothing. You may use it in selects/queries as "... where mycolumn is NULL' "(means contains no data at all).

Regards, Bernd
Sep 26 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.