473,386 Members | 1,733 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

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

6
Can we have spaces as values in the columns of database ?
If so, are they equivalent to null values ?
Sep 25 '07 #1
1 1057
docdiesel
297 Expert 100+
Hi,

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

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

Similar topics

8
by: william | last post by:
Hi Whwn I select from database using ADO.NET, if the data is null value in database, how should I handle it (string, integer, boolean type field) Thank willia
1
by: garimapuri | last post by:
hi ihad an array in php and iwant to insert its value in database the coding is: <?php $nv_pairs = explode('&',$query_string); $array; list ($name, $value) = explode ('=',$nv_pairs); $i = 0;...
3
by: NishChaks | last post by:
Hi, I am new to AJAX and having a small problem. I have a textbox control which on validating should get a value from database and assign it to one more textbox. Can anyone please help me on...
3
by: kang jia | last post by:
hi i retrieved value from database and now would to put these value inside a textarea. however, it seems cant put in, but the value can be retrieved from database. i don;t know where is wrong, ...
1
by: julianomartins | last post by:
Hi friends, how I make to recoup the value of database and to keep selected in combobox to edit my form? in script below it is selected field of the table that possesss id of the first item of...
1
by: suraj srivastava | last post by:
if we want find the value witout database connection,we want value retrieve from datagrid at .aspx pages at run time. we want to connection of the pages of data value throw datagrid . how will we...
1
by: arial | last post by:
I am having problem inserting checkbox value into database table. My database field is of type char(1). and my code is like this: string cc= null; if (chkdiscipline.checked) { cc = "T";
1
by: bhargavi514 | last post by:
friends i need the code to retrieve value from database and display value in text area using php
2
by: mindi | last post by:
how to retrieve single value form database without using result set. like i need only integer max(acc_id) from database and need to store in a variable
4
by: coder86 | last post by:
Hi, I am new to this site . I am looking for some help in updating my database from the value selected by user. Heres my page I have a table with rows of ID and its status. Status is a drop...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.