Re: Urgent!!! Null and empty string problem

From: Tracy Wang <twang1_at_exchange.ml.com>
Date: Tue, 14 Mar 2000 16:00:01 -0500
Message-ID: <8am9jf$8pg$1@news.ml.com>

you can insert a space (' ') instead of empty.

tracy

Mike Ng <mike_at_email.tech-trans.com> wrote in message news:38c86392_1_at_news1.prserv.net...
> hi all,
>
> I'm trying to insert a value empty string ( '' ) into a field which is not
> null but it prompt me error message. In other database, it is different
> between empty string and null, and allow adding the empty string to the
> field which is not null. However, the Oracle seems to be confuse them. Can
> anyone give me some hints so I can do that?
>
> Thank you
>
> Regards,
> Mike
>
>
Received on Tue Mar 14 2000 - 15:00:01 CST