Skip site navigation (1) Skip section navigation (2)

create a database with encoding LATIN1

From: Didier Gasser-Morlay <didiergm(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Cc: sebastien(at)hollox(dot)net
Subject: create a database with encoding LATIN1
Date: 2011-05-03 14:51:43
Message-ID: BANLkTik5O5psZT8SKBjB4B+hOoEJh8Yyyw@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
This is how I do it: when you setup your db cluster, chose the locale 'C'
this will let you select LATIN1 as a database encoding. (or as fas as I
understand, any other encoding)

If you let it at the default value, the cluster lc is defaulted to the
serveur local charset, in your case UTF8 - English_Canada.1252 (as would any
modern windows/linux server be nowadays)

Hope this helps
Didier

Responses

pgsql-novice by date

Next:From: Karsten HilbertDate: 2011-05-03 14:54:30
Subject: Re: [ADMIN] Can we Flush the Postgres Shared Memory ?
Previous:From: Grzegorz SzpetkowskiDate: 2011-05-03 14:37:14
Subject: Re: create a database with encoding LATIN1

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group