AW: [Zope-DB] Oracle... FieldType:number(n,m)

Dieter Fischer dieter.fischer@grid-it.ch
Mon, 13 Jan 2003 17:30:30 +0100


Hello

I think, this is either an Apache or an Zope missing the proper Oracle
environment:

File:	/etc/sysconfig/apache

ORACLE_HOME=3D/opt/oracle/product/oracle; export ORACLE_HOME
NLS_LANG=3D${NLS_LANG=3D"GERMAN_SWITZERLAND.WE8ISO8859P1"}; export NLS_LA=
NG
NLS_NUMERIC_CHARACTERS=3D".,"

File: /zope-home/.bashrc

export NLS_LANG=3DGERMAN_SWITZERLAND.WE8ISO8859P1
export NLS_NUMERIC_CHARACTERS=3D".,"
export PATH=3D/usr/local/ActivePython-2.1/bin:$PATH

Don't forget to change the values to your needs (sonst hast du z.B. kein
Eszet ;-) )

Regards

Dieter

> -----Urspr=FCngliche Nachricht-----
> Von: zope-db-admin@zope.org [mailto:zope-db-admin@zope.org]Im Auftrag
> von centershock@t-online.de
> Gesendet am: Montag, 13. Januar 2003 16:17
> An: zope-db@zope.org
> Betreff: [Zope-DB] Oracle... FieldType:number(n,m)
>
> Ahoi Folks,
>
> I have problems to read a field from a Oracle Database. The Type of the
> Field is number(n,m)... so its a float. If I get the value through
> Zope, I always get a rounded value e.g. 12.23 --> 12.00! In the Oracle
> Database the values are correct Float-Values. It's also possible to
> write correct Float-Values into the Table. Perhaps it's because my Zope
> runs in German language. If someone knows this problem please mail me!
>
> Environment:
> os: w2k
> zope 2.6.0 german language
> oracle 8.0
>
> cYa
>
> _______________________________________________
> Zope-DB mailing list
> Zope-DB@zope.org
> http://lists.zope.org/mailman/listinfo/zope-db
>