Are you confusing a NULL with an empty (zero length) string? They are not the same.
Regards. rayB |---------+----------------------------> | | "Nguyen Dang | | | Quang" | | | <[EMAIL PROTECTED]| | | m> | | | | | | 24/05/2006 16:08 | | | Please respond to| | | sqlite-users | | | | |---------+----------------------------> >--------------------------------------------------------------------------------------------------------------| | | | To: <sqlite-users@sqlite.org> | | cc: | | Subject: - [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 application still insert emty string into DIRECTORY field Why? It's a bug? How can I solve this problems? Thanks ************** PLEASE CONSIDER OUR ENVIRONMENT BEFORE PRINTING ************* ******************* Confidentiality and Privilege Notice ******************* This e-mail is intended only to be read or used by the addressee. It is confidential and may contain legally privileged information. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone, and you should destroy this message and kindly notify the sender by reply e-mail. Confidentiality and legal privilege are not waived or lost by reason of mistaken delivery to you. Qantas Airways Limited ABN 16 009 661 901 Visit Qantas online at http://qantas.com ****************************************************************************