Re: change encoding ? - Mailing list pgsql-general

From Pavel Stehule
Subject Re: change encoding ?
Date
Msg-id Pine.LNX.4.44.0501272241400.7321-100000@kix.fsv.cvut.cz
Whole thread Raw
In response to change encoding ?  (raptor <raptor@tvskat.net>)
List pgsql-general
Hello,
there is no possibility change encoding after database is created. You
can only change dynamic encoding for clients,

example: czech environment use cp1250 for win clients and latin2 for
others clients generally. I init in initdb databse for latin2 encoding. If
some people goes from latin2 systems, all is ok. But if somebody use
windows, he have to use first sql command
set client_encoding to 'cp1250';

but if you wont to change server encoding you have to usually dumpdb,
reinitdb and loaddb. init is not nessery if new encoding is same as used
locales.

Regards
Pavel Stehule


On Thu, 27 Jan 2005, raptor wrote:

> hi,
>
> how to change encding of already created database wo win-1251 ?
>
> tia
>
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
>


pgsql-general by date:

Previous
From: Steve Wampler
Date:
Subject: Re: how to read do the psq \i command
Next
From: Max
Date:
Subject: Re: GiST index not used for ORDER BY?