Hi
I have a postgres compiled with -mb=KOI8, store cyrillic data, get in the
client using different encoding (SET ENCODING=WIN1251, KOI8). The question
is: what should return stored procedure if I want to see it's output in
different encodings? Win1251, KOI8, UTF-8, something else?

Thanks in advance
Andriy Korud, Lviv, Ukraine.


5 Nov 1999 13:24:44 +0200
"Andrij Korud" <akorud@polynet.lviv.ua>
Encoding in UDF's
On 5 Nov 1999, Andrij Korud wrote:
> I have a postgres compiled with -mb=KOI8, store cyrillic data, get in the
> client using different encoding (SET ENCODING=WIN1251, KOI8). The question
> is: what should return stored procedure if I want to see it's output in
> different encodings? Win1251, KOI8, UTF-8, something else?

   Never tried it myself, but I'd expect windows-1251...

   SET PGCLIENTENCODING=WIN, of course.

Oleg.
---- 
    Oleg Broytmann      Foundation for Effective Policies      phd@phd.russ.ru
           Programmers don't die, they just GOSUB without RETURN.


Fri, 5 Nov 1999 14:32:49 +0000 (GMT)
Oleg Broytmann <phd@phd.russ.ru>
Re: [HACKERS] Encoding in UDF's
> I have a postgres compiled with -mb=KOI8, store cyrillic data, get in the
> client using different encoding (SET ENCODING=WIN1251, KOI8). The question
				       ~~~~~~~~CLIENTENCODING
> is: what should return stored procedure if I want to see it's output in
> different encodings? Win1251, KOI8, UTF-8, something else?

I assume you mean "stored procedure" as user defined functions.

Since you have created your database with KOI8, any proccessing within
the backend is done in KOI8 no matter what client encodings are used.

So the answer is:
Your fuction would see the input data in KOI8 and should return data
in KOI8 too.
---
Tatsuo Ishii

Sat, 06 Nov 1999 13:47:02 +0900
Tatsuo Ishii <t-ishii@sra.co.jp>
Re: [HACKERS] Encoding in UDF's 