Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Null and empty string
In Oracle null and empty string are the same. Not ANSI standard, but that's
the way it is.
-- Terry Dykstra Canadian Forest Oil Ltd. "Marko Mikulicic" <nospam_at_spamseul.org> wrote in message news:9n2i8n$fb3b$1_at_as201.hinet.hr...Received on Tue Sep 04 2001 - 10:24:45 CDT
> Hello,
>
> I'm new to oracle.
> I don't understand how can empty strings be the same as NULL.
> I don't know if it is an ansi sql standard or not but
> I thought that logically (like in postgresql) empy strings
> are different objects from "null".
>
> However, I have the following problem:
> Because of an unknown ORA-32255 error I can't read rows
> wich contain null clob values.
> But I need the possibility of empty fields (null or empty is
> not important for me in this case). But when I set a value to
> '' it is interpreted as a "null" and the ORA-32255 error comes back.
>
> Does anyone know a way around this ?
> Thanks,
>
> Marko Mikulicic
>
> PS:
> I'm using a wrapper library around OCI (a clone of EOF 1.0 called gstep-db
> that works well.)