I've done some more investigations on the problem below.=20
The wrong handling happens for _both_ 'real' and 'decimal' datatypes,
'money' is fine
I triple-checked my settings and even reinstalled the _german_ SQL
client on my machine...no improvement... played with different versions
of the db / net library...no improvement....toggled 'use international
settings in windbver.exe....no improvement....
_Any_ ideas?? Maybe _the_ idea :) ?
Frustrated.....Peter
>----------
>Von: Peter A. Sang
>Gesendet: Montag, 24. M=E4rz 1997 10:16
>An: 'Dale E. Reed Jr.'
>Cc: 'daler@comtch.iea.com'
>Betreff: Emerald/SQL intern. settings :(
>Dringlichkeit: Hoch
>
>Hi Dale,
>
>just stomped over a strange (at least interesting) effect which could =
be the
>cause for parts of our 'international' problems:
>
>(ISQL/W: select * from accounttypes:)
>
>WWW | 100,00 | WWW-ServerTraffic | 0 | 1 | 15.000 | 6 | 0,00 | (null) |
>(null) =20
>
>Please note that 'cost' and 'setupcharge' (both 'money') are displayed
>correctly with comma, whereas 'tax' (decimal 5,3) is written in =
'dotted'
>notation. (It should be 15% tax)
>
>I found that the SAME applies for db.discounts/percent, it's also =
displayed
>with a dot. (
>
>THIS CANNOT WORK!!!!!!!!!!!!!!!
>
>Any idea where to look for the cause? Do this fields in question NEED =
to be
>'Decimal', or can I change them to REAL'??
>(HMMM, I just saw that discounts/percent IS already real in
>Insttabs.SQL!!!!?????
>[...ignore that....'real' gives the same problem ...]
>What shall I do????????
>
>A soon reply -at least a ping- would be great .....
>
>cu, Peter
>
>Mit freundlichem Gru=DF,
>Best regards,
>-
>Peter A. Sang
>SANG Computersysteme GmbH * Kruppstr. 82-100 * 45145 Essen * Germany
>T: +49-201-82020-0 * F:-40 * http://sang.net * mailto:pesa@sang.net
>* Microsoft Solution Provider * Intel Systems Integrator *
>
>