From: [EMAIL 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
"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 N
ginal Message-
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 fiel
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][varch
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] Ho
"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,
>
> [metad
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 (
[desc
7 matches
Mail list logo