Re: [firebird-support] Record null on default '0'

@Ann Harrison,

I already have that record and default '0' before storing data..

Actual data,
Abnornal recard just 7 record from 7329 record at 6 and 7 may 2011. After that and untill now data normal (default '0').

Thanks


Sent from my BlackBerry® smartphone from Sinyal Bagus XL, Nyambung Teruuusss...!

-----Original Message-----
From: Ann Harrison <aharrison@ibphoenix.com>
Sender: firebird-support@yahoogroups.com
Date: Tue, 24 May 2011 11:48:32
To: <firebird-support@yahoogroups.com>
Reply-To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Record null on default '0'

On Tue, May 24, 2011 at 8:43 AM, <allies_xposs@yahoo.com> 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

[Non-text portions of this message have been removed]

------------------------------------

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu. Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-digest@yahoogroups.com
firebird-support-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/