adding a non null invisible value in field

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
jarow
Forum Commoner
Posts: 83
Joined: Tue Jan 28, 2003 2:58 am

adding a non null invisible value in field

Post by jarow »

How can I do the following?

I need a default value for a field , something like a space or something similar, that would act as a non-null value for a field, yet would not yield visible results.

Does that make any sense ?

In other words, a default value that the database thinks is a real value but it is not visible.

thanks

Jarow
ckuipers
Forum Commoner
Posts: 61
Joined: Mon Mar 24, 2003 6:10 am

Post by ckuipers »

You can set default values when creating the tables. When no values are added to that column, it will default. I assume (haven't tried it though) you can default to a space, or maybe even a blank.

Besides that you can have PHP edit your defaults (NULL) to process them before parsing them. Have you tried parsing these NULLs as I think they don't appear...
Post Reply