Re: [sqlite] NOT NULL in create table command not work

On 5/23/06, Nguyen Dang Quang <[EMAIL PROTECTED]> wrote: But my application still insert emty string into DIRECTORY field An empty string? Or NULL? There is a difference.

[sqlite] Re: - [sqlite] NOT NULL in create table command not work

Are you confusing a NULL with an empty (zero length) string? They are not the same. Regards. rayB |-+> | | "Nguyen Dang | | | Quang" | | | <[EMAIL PROTECTED]| | | m>

[sqlite] NOT NULL in create table command not work

Hi guys, I used the following command to create table: create table ne(ne_id integer primary key autoincrement, name varchar(50) not null, directory varchar(256) not null, adaptor_name varchar(50) not null, note varchar(500), filter_rule varchar(50), unique(name), unique(directory)) But my