Re: Enum issue

2007-01-10 Thread Joerg Bruehe
Hi Olaf, all ! Olaf Stein wrote: Hi All If I have a column `consent` enum('Y','N','P') default NULL, And I try to insert 'NULL' I get this error: Warning: Data truncated for column 'consent' at row 1 What is the problem there? Double-check your command: 'NULL' is a string of four (4) lett

Re: Enum issue

2007-01-09 Thread ViSolve DB Team
Hi, Try with, , `consent` enum ('','Y','N','P') , .mysql> desc table; +---+--+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | +---+--+--+-+-+---+ . | consent | enum