AW: AW: AW: [ZOPE] DCOracle2 and Oi9 RC2, wrong number values in select

[Dieter Fischer]

Hello

Regarding my Problem on Wednesday, I've found a good solution to that.

Before starting Zope, you have to set the correct environment Varible for
the decimal sign:

NLS_NUMERIC_CHARACTERS=3D".,"; export NLS_NUMERIC_CHARACTERS

Now you can start zope.

Regards

Dieter

>-----Urspr=FCngliche Nachricht-----
>Von: zope-admin@zope.org [mailto:zope-admin@zope.org]Im Auftrag von
>Matthew T. Kromer
>Gesendet am: Mittwoch, 2. Oktober 2002 23:10
>An: Dieter Fischer
>Cc: Zope@Zope.Org
>Betreff: Re: AW: AW: [ZOPE] DCOracle2 and Oi9 RC2, wrong number values
>in select
>
>Dieter Fischer wrote:
>
>>Hello
>>
>>I've found a method to get my values correcly, but I'm not very satisfi=
ed
>>with it:
>>
>>Giving zope the parameter (e.g python z2.py -Lde_CH, I hope this is
>>correct), didn't help.
>>
>>So I changed the ZSQL method to that:
>>
>>alter session set nls_language =3D 'AMERICAN'
>><dtml-var sql_delimiter>
>>alter session set nls_territory =3D 'AMERICA'
>><dtml-var sql_delimiter>
>>select * from zahlen
>>
>>and this works. But my defaults are:
>>
>>nls_language =3D 'GERMAN'
>>nls_territory =3D 'SWITZERLAND'
>>
>>Do I have now a problem with Zope or DCOracle2?
>>
>>Regards
>>
>>Dieter
>>
>>
>>
>
>What is the value of your LANG environment variable?   DCOracle2 is
>using the C conversion functions to convert from string results (for
>precision) to the python result types.  This function will change its
>parsing behavior based on your LANG environment variable setting.  In
>other words, it will work when whatever sscanf(3) can parse will work.
>
>--
>Matt Kromer
>Zope Corporation  http://www.zope.com/
>
>
>
>_______________________________________________
>Zope maillist  -  Zope@zope.org
>http://lists.zope.org/mailman/listinfo/zope
>**   No cross posts or HTML encoding!  **
>(Related lists -
> http://lists.zope.org/mailman/listinfo/zope-announce
> http://lists.zope.org/mailman/listinfo/zope-dev )
>