Inserting blanks into a NOT NULL CHAR column
363812Oct 31 2002 — edited Dec 2 2008How do you insert a value of blank/spaces into a NOT NULL CHAR column. Oracle 9i interprets the space as a NULL and the insert fails because the column does not allow NULLS. Thanks in advance.