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 :) ?
>Von: Peter A. Sang
>Gesendet: Montag, 24. M=E4rz 1997 10:16
>An: 'Dale E. Reed Jr.'
>Betreff: Emerald/SQL intern. settings :(
>just stomped over a strange (at least interesting) effect which could =
>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) |
>Please note that 'cost' and 'setupcharge' (both 'money') are displayed
>correctly with comma, whereas 'tax' (decimal 5,3) is written in =
>notation. (It should be 15% tax)
>I found that the SAME applies for db.discounts/percent, it's also =
>with a dot. (
>THIS CANNOT WORK!!!!!!!!!!!!!!!
>Any idea where to look for the cause? Do this fields in question NEED =
>'Decimal', or can I change them to REAL'??
>(HMMM, I just saw that discounts/percent IS already real in
>[...ignore that....'real' gives the same problem ...]
>What shall I do????????
>A soon reply -at least a ping- would be great .....
>Mit freundlichem Gru=DF,
>Peter A. Sang
>SANG Computersysteme GmbH * Kruppstr. 82-100 * 45145 Essen * Germany
>T: +49-201-82020-0 * F:-40 * http://sang.net * mailto:firstname.lastname@example.org
>* Microsoft Solution Provider * Intel Systems Integrator *