Solved tnks... createdb -E LATIN1 -O yyyy -T template0 --lc-collate=pt_BR --lc-ctype=pt_BR xxxx
Paulo ________________________________ De: Osvaldo Kussama <[email protected]> Para: paulo matadr <[email protected]> Enviadas: Segunda-feira, 13 de Dezembro de 2010 16:14:36 Assunto: Re: [GENERAL] Res: [ADMIN] Cluster with LATIN1 and UTF-8 2010/12/13 paulo matadr <[email protected]>: > I dont find way to create cluster... with example: > psql -l > teste1 |admin | LATIN1 > teste2 | postgres | SQL_ASCII > teste3 | admin2 | UTF8 > > -bash-3.1$ psql --version > psql (PostgreSQL) 8.3.5 > on this version in another server, it's working.. > but I cant repeat on postgres 9 . > > > > > > Paulo > > ________________________________ > De: Gabriele Bartolini <[email protected]> > Para: paulo matadr <[email protected]> > Cc: admin <[email protected]> > Enviadas: Segunda-feira, 13 de Dezembro de 2010 13:11:20 > Assunto: Re: [ADMIN] Cluster with LATIN1 and UTF-8 > > Ciao Paulo, > > Il 13/12/10 14:22, paulo matadr ha scritto: > > Im try install postgres 9.0 on rhel > and I try install cluster with 2 options of databases LATIN1 and UTF-8. > It's possible? > > Yes it is. I suggest that you look at the "ENCODING" option for the CREATE > DATABASE command: > > http://www.postgresql.org/docs/9.0/interactive/sql-createdatabase.html > > Hope this helps. > See an example in manual: http://www.postgresql.org/docs/current/interactive/multibyte.html#AEN30690 Osvaldo
