From: | Elielson Fontanezi <ElielsonF(at)prodam(dot)sp(dot)gov(dot)br> |
---|---|
To: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | Locale Style - American numeric values to European numeric values |
Date: | 2002-07-31 18:27:12 |
Message-ID: | A799F7647794D311924A005004ACEA97080DDEF3@cprodamibs249.prodam |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Elielson Fontanezi | 2002-07-31 18:35:13 | Locale Style - American numeric values to European numeri c values |
Previous Message | Chad R. Larson | 2002-07-31 18:22:55 | Re: 3-tier |