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

Dieter Fischer dieter.fischer@grid-it.ch
Wed, 2 Oct 2002 23:03:19 +0200


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