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=".,"; export NLS_NUMERIC_CHARACTERS Now you can start zope. Regards Dieter
-----Ursprüngliche 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 satisfied 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 = 'AMERICAN' <dtml-var sql_delimiter> alter session set nls_territory = 'AMERICA' <dtml-var sql_delimiter> select * from zahlen
and this works. But my defaults are:
nls_language = 'GERMAN' nls_territory = '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 )