[sqlite] NOT NULL in create table command not work

[Nguyen Dang Quang]

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 application still insert emty string into DIRECTORY field

Why? It's a bug? How can I solve this problems?

Thanks