Locale Style - American numeric values to European numeric values
От | Elielson Fontanezi |
---|---|
Тема | Locale Style - American numeric values to European numeric values |
Дата | |
Msg-id | A799F7647794D311924A005004ACEA97080DDEF3@cprodamibs249.prodam обсуждение исходный текст |
Список | 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
В списке pgsql-admin по дате отправления: