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

Re: BUG #4328: help in creating database encoded with LATIN1

From: valgog <valgog(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #4328: help in creating database encoded with LATIN1
Date: 2008-07-29 10:26:00
Message-ID: 205ff8db-3502-46ff-a3aa-7d84337d3e68@z66g2000hsc.googlegroups.com (view raw or flat)
Thread:
Lists: pgsql-bugs
On Jul 28, 8:27 am, rtz_a(dot)(dot)(dot)(at)yahoo(dot)com ("andrew victoria") wrote:
> The following bug has been logged online:
>
> Bug reference:      4328
> Logged by:          andrew victoria
> Email address:      rtz_a(dot)(dot)(dot)(at)yahoo(dot)com
> PostgreSQL version: 8.3.1
> Operating system:   fedora core 9
> Description:        help in creating database encoded with LATIN1
> Details:
>
> i got an error message
> createdb: database creation failed: ERROR:  encoding LATIN1 does not match
> server's locale en_US.utf8
> DETAIL:  The server's LC_CTYPE setting requires encoding UTF8.
>
> when im trying to create a database encoded with LATIN1 which is needed in
> our work. what will i do?
>
> many thanks en more power..
>
> --
> Sent via pgsql-bugs mailing list (pgsql-b(dot)(dot)(dot)(at)postgresql(dot)org)
> To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-bugs

Using LATIN1 encoding will introduce a lot of problems for you, in
case you will need to use characters that are out of LATIN1 scope
later. Think twice before counting 'pros' of having LATIN1 encoding (I
do not see the 'pros' in case you are using US ASCII symbols mainly,
as UTF8 will keep them 1 byte long (ASCII actually), and if you
occasionally will have to use some other non-LATIN1 symbols (and there
are many), you will not be able to change the encoding on the running
system without several hours of system downtime and you having a
headache doing initdbs, backups and restores).

-- Valentine Gogichashvili




In response to

pgsql-bugs by date

Next:From: Magnus HaganderDate: 2008-07-29 13:41:11
Subject: Re: RES: BUG #4322: Problems with field not updatable
Previous:From: Volker RudolphDate: 2008-07-29 09:48:02
Subject: BUG #4331: Postgres Installer doesn't provide complete library files

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