> Sorry guys about bothering you again, but..
>
> I ve re-created my database and i used DEFAULT NULL to create the tables,
> but it seens that it still leave the data "blank" on the field, is there
> some way to write NULL in the field if i send a blank data? or i ll have

to

The DEFAULT clause is only useful if you don't send ANYTHING for
that particular column...

eg:

create table default_test ( i integer default 4, i2 integer )

insert into default_test (i2) values (1);

This will insert the default for column "i".

> change all my php code to send NULL instead of a empty data?

If you want to store NULL, send NULL.

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com