Re: [HACKERS] UTF-8 support

2001-10-07 Thread Serguei Mokhov
- Original Message - From: Tatsuo Ishii <[EMAIL PROTECTED]> Sent: Monday, September 24, 2001 3:12 AM > > Which ones belong to the backend and which ones to the frontend? > > Or even more: which ones belong to the backend, which ones > > to the frontend #1, which ones to the frontend #2,

Re: [ODBC] [HACKERS] UTF-8 support

2001-10-02 Thread Dave Page
> -Original Message- > From: Tatsuo Ishii [mailto:[EMAIL PROTECTED]] > Sent: 24 September 2001 08:13 > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; > [EMAIL PROTECTED] > Subject: Re: [ODBC] [HACKERS] UTF-8 support > > > > Whi

Re: [ODBC] [HACKERS] UTF-8 support

2001-10-01 Thread Dave Page
> -Original Message- > From: Tatsuo Ishii [mailto:[EMAIL PROTECTED]] > Sent: 24 September 2001 00:58 > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] > Subject: Re: [ODBC] [HACKERS] UTF-8 support > > Currently no. But it would be easy to impl

Re: [ODBC] [HACKERS] UTF-8 support

2001-09-25 Thread Jean-Michel POURE
Hello, Are there built-in functions to convert UTF-8 string values into hexadecimal \u and octal values and conversely? If yes, can I parse any UTF-8 string safely with PL/pgSQL to return \u and octal values? Best regards, Jean-Michel POURE ---(end of broadcas

Re: [HACKERS] UTF-8 support

2001-09-24 Thread Tatsuo Ishii
> Which ones belong to the backend and which ones to the frontend? > Or even more: which ones belong to the backend, which ones > to the frontend #1, which ones to the frontend #2, etc... > > For examle, I have two fronends: > > FE1: UNICODE, WIN1251 > FE2: KOI8, UNICODE > BE: UNICODE, LATIN1,

Re: [HACKERS] UTF-8 support

2001-09-23 Thread Serguei Mokhov
- Original Message - From: Tatsuo Ishii <[EMAIL PROTECTED]> Sent: Sunday, September 23, 2001 10:47 PM > > My question is now how many BE's/FE's would you return encodings for? > > I don't quite understand your question. What I thought were something > like this: > > SELECT pg_available

Re: [HACKERS] UTF-8 support

2001-09-23 Thread Tatsuo Ishii
> > pg_available_encodings([INTEGER how]) RETURNS setof TEXT > > > > where how is > > > > 0(or omitted): returns all available encodings > > 1: returns encodings in backend > > 2: returns encodings in frontend > > > > Comments? > > 3: returns encodings of both backend

Re: [HACKERS] UTF-8 support

2001-09-23 Thread Serguei Mokhov
- Original Message - From: Tatsuo Ishii <[EMAIL PROTECTED]> Sent: Sunday, September 23, 2001 7:58 PM > > 3) Is there a way to query available encodings in PostgreSQL for display in > > pgAdmin. > > Is it a planned feature in PostgreSQL 7.2? This would be nice if it existed. > > Example:

Re: [HACKERS] UTF-8 support

2001-09-23 Thread Tatsuo Ishii
> 1) UTF-8 > http://www.postgresql.org/idocs/index.php?app-psql.html explains > "Anything contained in single quotes is furthermore subject to C-like > substitutions for \n (new line), \t (tab), \digits, \0digits, and \0xdigits > (the character with the given decimal, octal, or hexadecimal code)

[HACKERS] UTF-8 support

2001-09-23 Thread Jean-Michel POURE
Hello, I have set up a UNICODE database in PostgreSQL 7.1.2 and use psql for querying (\ENCODING > UNICODE). To perform tests, I downloaded code charts from http://www.unicode.org/charts/ 1) UTF-8 http://www.postgresql.org/idocs/index.php?app-psql.html explains "Anything contained in single quo