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

[Anthony T. <ant...@gm...>]

Oracle is interesting in this respect. An empty string is implicitly
changed to NULL in Oracle -- thus nvl(column, "") is pointless since
you'll get null back anyway. :-)

On 5/11/05, Chris Dunscombe <cdu...@ya...> wrote:
> Marcos,
>=20
> Great idea (nvl as opposed to isnull). However cx_Oracle still returns No=
ne e.g.
>=20
> cur1.execute("select nvl(subobject_name,'') from objects_big where rownum=
 < 5")
> data =3D cur1.fetchall()
> print data
> [(None,), (None,), (None,), (None,), (None,)]
>=20
> I thought you'd "fixed it". Thanks for the idea anyway.
>=20
> Chris
>=20
> --- Marcos S=E1nchez Provencio <ma...@bu...> wrote:
>=20
> > you may try to do it at oracle level
> >
> > select isnull(col,'')...
> >
> > it should be faster
> >
> > El mi=E9, 11-05-2005 a las 07:15 -0700, Chris Dunscombe escribi=F3:
> > > All,
> > >
> > > Is there anyway that Null values returned from a query can be an "emp=
ty or zero length string"
> > > instead of None?
> > >
> > > This may seem a strange request as it's easy to use type to test if a=
 null has been returned
> > as
> > > None. However I've a performance critical app where I need to output =
"nothing" (zero length /
> > > empty string) if the value is null. Hence at present I have to perfor=
m this "type test" on ALL
> > > columns that don't have a "Not Null" constraint in the database which=
 is quite an overhead
> > when in
> > > some cases I need to do it millions and sometimes billions of times.
> > >
> > > Thanks,
> > >
> > > Chris Dunscombe
> > >
> > >
> > >
> > > __________________________________
> > > Do you Yahoo!?
> > > Read only the mail you want - Yahoo! Mail SpamGuard.
> > > http://promotions.yahoo.com/new_mail
> > >
> > >
> > > -------------------------------------------------------
> > > This SF.Net email is sponsored by Oracle Space Sweepstakes
> > > Want to be the first software developer in space?
> > > Enter now for the Oracle Space Sweepstakes!
> > > http://ads.osdn.com/?ad_id=3D7393&alloc_id=3D16281&op=3Dclick
> > > _______________________________________________
> > > cx-oracle-users mailing list
> > > cx-...@li...
> > > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
> >
> >
> >
> > -------------------------------------------------------
> > This SF.Net email is sponsored by Oracle Space Sweepstakes
> > Want to be the first software developer in space?
> > Enter now for the Oracle Space Sweepstakes!
> > http://ads.osdn.com/?ad_ids93&alloc_id=16281&op=3Dclick
> > _______________________________________________
> > cx-oracle-users mailing list
> > cx-...@li...
> > https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
> >
>=20
> Discover Yahoo!
> Stay in touch with email, IM, photo sharing and more. Check it out!
> http://discover.yahoo.com/stayintouch.html
>=20
>=20
> -------------------------------------------------------
> This SF.Net email is sponsored by Oracle Space Sweepstakes
> Want to be the first software developer in space?
> Enter now for the Oracle Space Sweepstakes!
> http://ads.osdn.com/?ad_id=3D7393&alloc_id=3D16281&op=3Dclick
> _______________________________________________
> cx-oracle-users mailing list
> cx-...@li...
> https://lists.sourceforge.net/lists/listinfo/cx-oracle-users
>