Cannot insert '' into NOT NULL column

Hello,

   I'm running Oracle 8.1.7 for Solaris. I have a situation where I want my primary key to potentially include a '' value. However, it appears Oracle treats '' the same as NULL, and of course, NULLs are not allowed in primary keys. Is there anything I can do to allow the oclumn to have a '' value AND index the column in some way? Or is the only solution to hard code into my application that if inserting a '', change it to something non-empty before the insert occurs?

Thanks - Dave Received on Thu Mar 18 2004 - 09:49:01 CST