Locale Style - American numeric values to European numeric values

Поиск
Список
Период
Сортировка
Искать

Locale Style - American numeric values to European numeric values

От:
Elielson Fontanezi <ElielsonF@prodam.sp.gov.br>
Дата:
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


FAQ