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

On Jul 28, 8:27=A0am, rtz_a...@yahoo.com ("andrew victoria") wrote:
> The following bug has been logged online:
>
> Bug reference: =A0 =A0 =A04328
> Logged by: =A0 =A0 =A0 =A0 =A0andrew victoria
> Email address: =A0 =A0 =A0rtz_a...@yahoo.com
> PostgreSQL version: 8.3.1
> Operating system: =A0 fedora core 9
> Description: =A0 =A0 =A0 =A0help in creating database encoded with LATIN1
> Details:
>
> i got an error message
> createdb: database creation failed: ERROR: =A0encoding LATIN1 does not ma=
tch
> server's locale en_US.utf8
> DETAIL: =A0The 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...@postgresql.org)
> To make changes to your subscription:http://www.postgresql.org/mailpref/p=
gsql-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