Need a help, please.
I have installed Oracle8i on Windows NT 4 (Service Pack 4) server and
created a database on it with default settings (by default it was
created with CL8ISO8859P5 ISO 8859-5 Latin/Cyrillic character set).
In this database I have created a table SCOTT.NAD with two fields:
id10_0 -> NUMBER(10,0)
id10_5 -> NUMBER(10,0) and filled with the following values:
id10_0 id10_5
0 0.5
1 1.5
2 2.5
When I used SQL "SELECT * FROM SCOTT.NAD" in SQL+ on the server the
results shown were the same as above.
Then I go to Windows NT Workstation (Russian edition, Service Pack 4 -
in Russian the default decimal separator is "," - comma) and use the
same SQL statment in SQL+ the results are following:
id10_0 id10_5
0 0,5
1 1,5
2 2,5
and this result doesn't depend on what is the value of decimal
separator ("," - comma or ".' - point) which is set through Control
Panel -> International Settings -> Numbers.
This is very strange and doesn't allow to work with database through
ODBC driver