Empty Fields or Null...

[handle87]

Hi,

In a MySQL table if you have a field that is empty, does it still hold that space?

And also, if you put a Null value in it does that change anything?

CES

 

[BabyJeffy]

See if you can reword your question in such a way that it makes sense.

Cheers,
Jeff

[tt]Jeff's Page [/tt][tt]@[/tt][tt] Code Couch

http://www.codecouch.com/jeff/

[/tt]

 

[handle87]

Sorry dude.. thought it was pretty clear...

You have a table..
two fields:
- FirstName
- LastName

One of the records has a FirstName and NO LastName and another record has Both FirstName and LastName do both records hold the same amount of space?

with number & datetime fields I found they do... what about a field that is type Text? In regards to MySQL.

So is the space of the field reserved..

is that clear?



CES

 

[sleipnir214]

Is there a PHP question here?

Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[handle87]

No there isnt... however I figured that someone probably knows the answer in this forum as PHP and MySQL are married... sorry to bother you. I found out the answer.

take care!

 

[hos2]

it depends how you declared the fields, if it's with char(30) for instance I believe that 30 characters are reserved even if you don't use them if you use varchar then non filled space is not added to you quota