Carlos Sousa writes: > (...) > var varchar2(50) default '' not null > (...) > > but when i was importing the the table into the oracle database all the rows > with the field var='' were not inserted. > Is there a way to work this around
Yes, don't use Oracle. In Oracle, '' is the same as null, so the constraint is not satisfied. -- Peter Eisentraut [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly