Hi fellow!
Problem: I am impossible to format numeric values from American to
European
style.
What have I done?
1. The Linux RH was settled to Brazilian locale:
LC_COLLATE=C
LC_CTYPE=C
LC_MESSAGES=pt_BR
LC_MONETARY=pt_BR
LC_NUMERIC=pt_BR
LC_TIME=pt_BR
2. PostGRE was compile with --enable-locale and
--enable-multibyte=UNICODE
3. $PGDATA was created doing: initdb -D $PGDATA -E UNICODE
4. In postgres db the table
create table leo(
codigo int2 primary key,
dia date,
valor numeric(10,2)
);
where
postgres$ psql -c "select * from leo";
codigo | dia | valor
--------+------------+--------
1 | 2002-02-02 | 200.00
(1 row)
The field dia and valor are still shown with american style.
What am I doing wrong.
Thanks.
..............................................
A Question...
Since before your sun burned hot in space
and before your race was born,
I have awaited a question.
Elielson Fontanezi
DBA Technical Support - PRODAM
Parque do Ibirapuera s/n - SP - BRAZIL
+55 11 5080 9493