Pois e porque nao usa latin1
no meu postgresql 8.3 no windows tenho de resposta para sua query ( usando o pgadmin) "client_encoding";"UNICODE" "lc_collate";"C" "lc_ctype";"C" "lc_messages";"C" "lc_monetary";"C" "lc_numeric";"C" "lc_time";"C" "server_encoding";"LATIN1" "server_version";"8.3.0" "server_version_num";"80300" []s Luiz ----- Original Message ----- From: Silfar Goulart To: Comunidade PostgreSQL Brasileira Sent: Wednesday, March 19, 2008 3:35 PM Subject: Re: [pgbr-geral] Encoding Rode o seguinte SQL: SELECT name, setting FROM pg_settings WHERE name ~ 'encoding|^lc_|version'; e veja os encodings em uso. "client_encoding";"UNICODE" "lc_collate";"Portuguese_Brazil.1252" "lc_ctype";"Portuguese_Brazil.1252" "lc_messages";"Portuguese_Brazil" "lc_monetary";"Portuguese_Brazil" "lc_numeric";"Portuguese_Brazil" "lc_time";"Portuguese_Brazil" "server_encoding";"UTF8" "server_version";"8.3.0" "server_version_num";"80300" SELECT datname, pg_encoding_to_char(encoding) FROM pg_database; lista o encoding de cada um de seus bancos de dados. "template0";"UTF8" "postgres";"UTF8" "template1";"UTF8" "sgda";"UTF8" Pode me dizer se isto está correto ? -- Silfar Goulart _______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral _______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
