Hello, 
i use openoffice 1.1.2, unixodbc 2.2.4, postgresql 7.4.3 with Debian Linux (on 
i386). All with german locales. 
With this i use tables and macros, over odbc-connection, and make an access to 
postgresql-database. The enviroment LANG is set to "de_DE@euro". This is 
correct. Openoffice use this. This all works fine. 
But Database-Values of type numeric (same as decimal) are displayed truncated. 
Openoffice show a value of 5,55 as 5,00 ("," not "." in german!) 
 
An Example 
In psql, The Postgresql-Database-Shell: 
CREATE TABLE tktest( intfeld integer, realfeld real, numericfeld numeric, 
numeric2feld numeric(9,2)}; 
INSERT INTO tktest(intfeld, realfeld, numericfeld, numeric2feld) VALUES(555, 
5.55, 5.55, 5.55); 
select * from tktest; 
 intfeld | realfeld | numericfeld | numeric2feld 
---------+----------+-------------+-------------- 
     555 |     5.55 |        5.55 |         5.55 
This is OK. 
 
In isql, The ODBC-Database-Shell: 
select * from tktest; 
+------------+--------------+-------------+-------------+ 
| intfeld    | realfeld     | numericfeld | numeric2feld| 
+------------+--------------+-------------+-------------+ 
| 555        | 5.5500002    | 5.55        | 5.55        | 
+------------+--------------+-------------+-------------+ 
This is OK. (I known, why i dont want to use real-types). 
 
And now i open the Databasebeamer of Openoffice with Hotkey F4. 
intfeld realfeld numericfeld numeric2feld 
555     5,55     5,000000    5,00 
 
Where is the "5,55" in numeric? Why this display 5,00? 
All vars in forms, they use this Values, display the same wrong content. 
The displayformat have no effect to this. 
- If i use a macro and calculate with this values, then are the calculate 
value are correct. 
- If i copy the Database to a calc-document, then all values are correct. 
- If i set the enviroment LANG to a unvalid value like "de_de@blablabla", then 
then all values are correct. But this is agly for the rest of the system. 
- If i unset the enviroment LANG, then all values are correct. But this 
provide openoffice to use the english language. Not usefull in germany. 
 
I read in the german openoffice-user-list, the same problem exists with mysql.  
 
Im think, this is a error of Openoffice?  
 
bye Thomas