Re: [cx-oracle-users] Nulls returned as None and not as as "empty or zero lenght string"

[Paul M. <p.f...@gm...>]

On 5/11/05, Marcos S=E1nchez Provencio <ma...@bu...> wrote:
> you may try to do it at oracle level
>=20
> select isnull(col,'')...

That won't work, precisely because Oracle doesn't distinguish between
NULL and ''. This is a problem with Oracle rather than anything else.

You might be able to get away with NVL(col, ' ') and return a single
space, but that is different from an empty string, and so may not
satisfy your application's requirements.

Paul.