RE: [sqlite] How Does NOT NULL produce NULLs?

AIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 29, 2008 12:39 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] How Does NOT NULL produce NULLs? "Lee Crain" <[EMAIL PROTECTED]> wrote: > I did expect SQLite to enforce the NOT NULL portion of the SQL >

Re: [sqlite] How Does NOT NULL produce NULLs?

"Lee Crain" <[EMAIL PROTECTED]> wrote: > I did expect SQLite to enforce the NOT NULL portion of the SQL > creation statements, no matter what. SQLite *does* enforce NOT NULL no matter what. I think your pointers are getting turned into NULLs someplace else, perhaps somewhere in the QT layer. A

RE: [sqlite] How Does NOT NULL produce NULLs?

age- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 29, 2008 12:02 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] How Does NOT NULL produce NULLs? "Lee Crain" <[EMAIL PROTECTED]> wrote: > I've created a table with several fields, 3 of which

Re: [sqlite] How Does NOT NULL produce NULLs?

On Jan 29, 2008 11:01 AM, <[EMAIL PROTECTED]> wrote: > "Lee Crain" <[EMAIL PROTECTED]> wrote: > > I've created a table with several fields, 3 of which are created using > > these SQL statements: > > > > [description] [varchar](255) NOT NULL DEFAULT ('') COLLATE NOCASE, > > > > [keywords]

RE: [sqlite] How Does NOT NULL produce NULLs?

Scott, I'm not ignoring your post. I'm going to respond to DRH's post. Thanks, Lee _ -Original Message- From: Scott Hess [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 29, 2008 11:54 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] How Does NOT NULL

Re: [sqlite] How Does NOT NULL produce NULLs?

"Lee Crain" <[EMAIL PROTECTED]> wrote: > I've created a table with several fields, 3 of which are created using > these SQL statements: > > [description] [varchar](255) NOT NULL DEFAULT ('') COLLATE NOCASE, > > [keywords][varchar](255) NOT NULL DEFAULT ('') COLLATE NOCASE, > >

Re: [sqlite] How Does NOT NULL produce NULLs?

That seems unlikely, since NULL wouldn't come out as the string (null) in any case. Most likely some higher layer is putting the literal '(null)' in for you when you insert. Please post a set of literal input to sqlite3 which demonstrates the problem. .nullvalue '[null]' create table x (

[sqlite] How Does NOT NULL produce NULLs?

I've created a table with several fields, 3 of which are created using these SQL statements: [description] [varchar](255) NOT NULL DEFAULT ('') COLLATE NOCASE, [keywords][varchar](255) NOT NULL DEFAULT ('') COLLATE NOCASE, [metadata][varchar](255) NOT NULL DEFAULT ('')