Re: Cannot insert '' into NOT NULL column

laredotornado_at_zipmail.com (D. Alvarado) wrote:

>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

2 Thoughts..
Change the '' to ' ' - A blank string, not a NULL

Or

Instead of a Primary Key use a Unique Index ( it allows for NULLs) ( but, that cannot be used as the 'target' of a Foreign Key)

hth

----== Posted via Newsfeed.Com - Unlimited-Uncensored-Secure Usenet News==---- http://www.newsfeed.com The #1 Newsgroup Service in the World! >100,000 Newsgroups ---= 19 East/West-Coast Specialized Servers - Total Privacy via Encryption =--- Received on Thu Mar 18 2004 - 12:43:48 CST