Oracle vinculated tables decimal error (1 Viewer)

[Akhorahil]

Hi!
I'm having a problem that "I can´t" solve.
I have made a program in Access with vinculated tables from oracle (ODBC).
In access when I'm going to use that tables or when I see the records on the table all the numbers with decimals shows without separators (,).
99,99 looks like 9999.
This is a big problem because I'm working with prices.

I tried to change the NSL_Language in Regedit to:
AMERICAN_AMERICA.WE8ISO8859P1
from:
SPANISH_SPAIN.WE8MSWIN1252

AND it works ONLY in my computer, when I try to fix it and change the languaje doesnt work, and i dont know why.

PD: In addition, in the other PC's, some characters seems wrong like "ª" that looks like a square.

Thanks for the help!

 

[spikepl]

What is datatype in Oracle ? And what is the actual value ? Same questions for Access. And for Access I don't mean looking at the table, but perform some calculation (e.g., add 1) and output the result, so you know what the real value is no matter the formatting.

 

[The_Doc_Man]

The character that looks like a square tells me that you have a font issue. Not all fonts are fully populated for all characters such as those with diacritical marks. Look at the fonts for the fields/controls displaying the funky characters and don't use those fonts again. Find fonts that "do the right thing" and remember to set the fonts accordingly.