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

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