Thread: Cluster with LATIN1 and UTF-8

Cluster with LATIN1 and UTF-8

From
paulo matadr
Date:
Hi all,
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?


 


Paulo


 

Re: Cluster with LATIN1 and UTF-8

From
Gabriele Bartolini
Date:
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.

Cheers,
Gabriele

-- Gabriele Bartolini - 2ndQuadrant ItaliaPostgreSQL Training, Services and Supportgabriele.bartolini@2ndQuadrant.it | www.2ndQuadrant.it

Res: Cluster with LATIN1 and UTF-8

From
paulo matadr
Date:
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 <gabriele.bartolini@2ndQuadrant.it>
Para: paulo matadr <saddoness@yahoo.com.br>
Cc: admin <pgsql-admin@postgresql.org>
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.

Cheers,
Gabriele

-- 
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele.bartolini@2ndQuadrant.it | www.2ndQuadrant.it

 

Res: [GENERAL] Res: Cluster with LATIN1 and UTF-8

From
paulo matadr
Date:
Solved  tnks...
createdb -E LATIN1 -O yyyy -T template0 --lc-collate=pt_BR --lc-ctype=pt_BR xxxx

Paulo



De: Osvaldo Kussama <osvaldo.kussama@gmail.com>
Para: paulo matadr <saddoness@yahoo.com.br>
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 <saddoness@yahoo.com.br>:
> 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 <gabriele.bartolini@2ndQuadrant.it>
> Para: paulo matadr <saddoness@yahoo.com.br>
> Cc: admin <pgsql-admin@postgresql.org>
> 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