--- Andy Bakun <[EMAIL PROTECTED]> wrote:
> On Sat, 2005-02-19 at 23:55, David Blomstrom wrote:
>
> > > Why not set columns to NOT NULL and default to
> space
> > > for character and 0
> > > for numeric?
> >
> > OK, you're suggesting I...
> >
> > 1. Set all the columns to NOT NULL
> > 2. Set 0 as the default for numeric fields
> > 3. Set "space" for the default in the other
> fields?
>
> Using a single space as the default for a column
> won't work because
> mysql trims (removes trailing whitespace) from
> inserted values.
>
> Doing something like this sounds like a really bad
> work around. The
> data you want should be stored and appear in the
> right columns.
OK, thanks.
__________________________________
Do you Yahoo!?
Yahoo! Mail - now with 250MB free storage. Learn more.
http://info.mail.yahoo.com/mail_250
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
