NULL Values

NULL Values

Post by A.M » Thu, 05 Sep 2002 16:27:22



Hi,

If i put NULL in a varchar(255) column, do i save HDD space?

Thanks,
Ali

 
 
 

NULL Values

Post by Narayana Vyas Kondredd » Thu, 05 Sep 2002 16:53:56


Yes
--
HTH,
Vyas, MVP (SQL Server)

http://vyaskn.tripod.com/


Quote:> Hi,

> If i put NULL in a varchar(255) column, do i save HDD space?

> Thanks,
> Ali


 
 
 

NULL Values

Post by Gert-Jan Stri » Thu, 05 Sep 2002 20:27:05


As of SQL-Server 7.0, a NULL in a varchar(255) column consumes the same
amount of disk space as an empty string: it will require 2 bytes.

Gert-Jan


> Hi,

> If i put NULL in a varchar(255) column, do i save HDD space?

> Thanks,
> Ali

 
 
 

1. Null values: Classic null value problem (?)

Whiles using a find command in an integer field that has only integers
(finding all values  < 1), it returns records that also include null
values, i.e. there are some records that are blank. They are blank
because the rest of the data in the record does not merit a value in
the the integer field. Also the null value does not mean zero either.
Zero is a valid result.

I would like to be able to search the integer field for all integers
include zero but not return the records with the null value.

Anyone know how this can be done with filemaker 4.0

Peter

--

2. SQL*PLUS simple problem...

3. inserting null values into not null column in Server 7.0

4. Oracle 8, waitpid interrupted system call

5. Determining a NULL/non NULL value

6. FL-MIAMI-ORACLE-DBA

7. Sending null strings and NULL values

8. NULL value in a NOT NULL field

9. Export Null values to Excel cause left shifted values in XLS

10. how to update column with null value by a new value

11. Overwriting a Date Value with a Null Value using SQLXML

12. replace NULL values with other values