Subject Re: [firebird-support] Record null on default '0'
Author Ann Harrison
On Tue, May 24, 2011 at 8:43 AM, <allies_xposs@...> wrote:
> All dba firebird,
>
> I have field varchar(1) default '0' on structure,
> But just 6 record have 'null' on 50000 record have '0'.
> Why..

Did you add the default value after storing some data? And, as an
aside, varchar(1) is an unusual usage. You're using two bytes for
the length of a one byte field that's never empty.

Good luck,

Ann