Take a look at SQL_MODE ;) Claudio
On Jan 30, 2010 5:05 PM, "Miao Jiang" <jiangfri...@gmail.com> wrote: When I try insert NULL to VARCHAR NOT NULL column, It will shows a warning and convert NULL to '' then insert 。 I want to MySQL raise an exception when I try do that. How to do that? Thank you. Miao -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=claudio.na...@gmail.com