Thread: change encoding ?

change encoding ?

From
raptor
Date:
hi,

how to change encding of already created database wo win-1251 ?

tia

Re: change encoding ?

From
Pavel Stehule
Date:
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
>