Re: [HACKERS] Encoding in UDF's - Mailing list pgsql-hackers

From Tatsuo Ishii
Subject Re: [HACKERS] Encoding in UDF's
Date
Msg-id 199911060447.NAA01487@ext16.sra.co.jp
Whole thread Raw
In response to Encoding in UDF's  ("Andrij Korud" <akorud@polynet.lviv.ua>)
List pgsql-hackers
> 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


pgsql-hackers by date:

Previous
From: Lamar Owen
Date:
Subject: PostgreSQL 6.5.3 STABLE RPMs released.
Next
From: Thomas Lockhart
Date:
Subject: Re: [HACKERS] PostgreSQL 6.5.3 built, but not released ...