On Sun, 15 Jul 2001 [EMAIL PROTECTED] wrote: > From: "Burkhard Vogel" <[EMAIL PROTECTED]> > Subject: Re: [JBoss-user] NOT NULL constraint > Date: Sun, 15 Jul 2001 16:27:21 +0200 > > AFAIK there is a setup parameter which indicates to treat '' as null or as > something different, but with oracle and its zillions of knobs to fiddle on, > who could remember where this button is?!? The SQL-99 standard treats empty strings differently than NULL's. I'm not sure about the latest Oracle (9i?), but in 8i '' [no space] IS a null. ' ' [space] is an empty string. empty string != null. Create a table with not null constraints and insert '' [no space] to see what I mean. kb -- Kenneth Bowen [EMAIL PROTECTED] /\ moc.xobop@newobk newoB htenneK Powered by Debian 2.2 | Mcq! / \ !qcM | 2.2 naibeD yb derewoP _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] http://lists.sourceforge.net/lists/listinfo/jboss-user
