Re: [ODBC] pgAdmin2 UTF-8 support

From: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
To: "'jm(dot)poure(at)freesurf(dot)fr'" <jm(dot)poure(at)freesurf(dot)fr>
Cc: pgadmin-hackers(at)postgresql(dot)org
Subject: Re: [ODBC] pgAdmin2 UTF-8 support
Date: 2002-02-25 08:29:00
Message-ID: FED2B709E3270E4B903EB0175A49BCB10475F6@dogbert.vale-housing.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-hackers

> -----Original Message-----
> From: Jean-Michel POURE [mailto:jm(dot)poure(at)freesurf(dot)fr]
> Sent: 25 February 2002 08:18
> To: Dave Page
> Cc: pgadmin-hackers(at)postgresql(dot)org
> Subject: Re: [pgadmin-hackers] [ODBC] pgAdmin2 UTF-8 support
>
>
> Dear Dave,
>
> I used pgsql with PostgreSQL 7.2 and noticed there was an automatic
> translation between UTF-8 <-> Latin characters. This is a new
> feature of
> PostgreSQL 7.2.
>
> So fine :
>
> Suppose we have a Unicode database :
> \Encoding Latin1 (\same with \Encoding SQL_ASCII does not
> work) INSERT INTO table_foo (field_bar) VALUES ('é'); SELECT
> field_bar FROM table_foo WHERE field_bar='é' works. I checked
> the UTF-8 display in Apache, it works.
>
> In the case of an UTF-8 database, it means we need to create
> and query schema
> objects using \Encoding Latin1. Should it be done at ODBC level or at
> pgAdmin2 level? What is your opinion?
>
> This could help us display non-multibyte UTF-8 data as well.

Presumably we should do this in SQL (I don't think you can do it in the ODBC
connect string can you?). Have you tried in pgAdmin:

SET CLIENT_ENCODING Latin1;
INSERT INTO table_foo (field_bar) VALUES ('é'); SELECT field_bar FROM
table_foo WHERE field_bar='é';

Regards, Dave.

Responses

Browse pgadmin-hackers by date

  From Date Subject
Next Message Jean-Michel POURE 2002-02-25 08:30:11 Re: [ODBC] pgAdmin2 UTF-8 support
Previous Message Dannyi@barak.net.il 2002-02-25 08:22:20 Re: [ODBC] pgAdmin2 UTF-8 support