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 по дате отправления:

Предыдущее
От: "Chad R. Larson"
Дата:
Сообщение: Re: 3-tier
Следующее
От: Elielson Fontanezi
Дата:
Сообщение: Locale Style - American numeric values to European numeri c values