2010/4/23 Diogo Castro <[email protected]>: > Bom dia, > > Alguém sabe a SOLUÇÃO para meu problema de encoding: > > [r...@srv08 opt]# createdb -U postgres -T template1 -E LATIN1 diogo > createdb: database creation failed: ERROR: encoding LATIN1 does not match > server's locale en_US.UTF-8 > DETAIL: The server's LC_CTYPE setting requires encoding UTF8. > > SO: rhel5 > locale: > [r...@srv08 opt]# locale > LANG=pt_BR.UTF-8 > LC_CTYPE="pt_BR.UTF-8" > LC_NUMERIC="pt_BR.UTF-8" > LC_TIME="pt_BR.UTF-8" > LC_COLLATE="pt_BR.UTF-8" > LC_MONETARY="pt_BR.UTF-8" > LC_MESSAGES="pt_BR.UTF-8" > LC_PAPER="pt_BR.UTF-8" > LC_NAME="pt_BR.UTF-8" > LC_ADDRESS="pt_BR.UTF-8" > LC_TELEPHONE="pt_BR.UTF-8" > LC_MEASUREMENT="pt_BR.UTF-8" > LC_IDENTIFICATION="pt_BR.UTF-8" > LC_ALL= > --
Apenas por curiosidade: Por quê você deseja utilizar LATIN1 no lugar de UTF-8? Dê uma olhada neste artigo: http://blog.divisiblebyfour.org/2008/03/postgresql-e-codificaes-postgresql-and.html Osvaldo _______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
