Subject Re: [firebird-support] Re: Weird php and firebird problem, repeating values
Author Martijn Tonies
> 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

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


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
Upscene Productions
Database development questions? Check the forum!