Should I use default null or some value ?

Posted in 2003

joseph v d'silva — 2 Jun 2003 04:36:40 -0700 — source: Usenet: comp.databases.informix

Hi, I need to add a char(1) column to one of my tables, I wan't to know if there is any difference between letting the column have a null value by default or assigning a default value like 'N'. Does both these cases take up the same space or are they different ? thanx

↪ replying to joseph v d'silva

Jonathan Leffler — Tue, 03 Jun 2003 05:37:04 GMT — source: Usenet: comp.databases.informix

joseph v d'silva wrote: > I need to add a char(1) column to one of my tables, I wan't to know > if there is any difference between letting the column have a null > value by default or assigning a default value like 'N'. Does both > these cases take up the same space or are they different ? They both occupy the same space - there is no difference. I'd use a non-null default unless there really is no suitable value (and even then I'd probably find one). -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2003.04 -- http://dbi.perl.org/