Skip site navigation (1) Skip section navigation (2)

Re: [ODBC] pgAdmin2 UTF-8 support

From: Jean-Michel POURE <jm(dot)poure(at)freesurf(dot)fr>
To: Dave Page <dpage(at)vale-housing(dot)co(dot)uk>
Cc: pgadmin-hackers(at)postgresql(dot)org
Subject: Re: [ODBC] pgAdmin2 UTF-8 support
Date: 2002-02-25 08:38:48
Message-ID: 200202250838.g1P8cmFP007883@www1.translationforge (view raw or flat)
Thread:
Lists: pgadmin-hackers
Le Lundi 25 Février 2002 09:29, Dave Page a écrit :
> SET CLIENT_ENCODING Latin1;
> INSERT INTO table_foo (field_bar) VALUES ('é'); SELECT field_bar FROM
> table_foo WHERE field_bar='é';

In case of an UTF-8 database,
- schema queries should always be sent in Latin1.
- SQL highlightbox should allow to choose client encoding on the fly in a 
combo.

How do we query current client encoding?

Cheers,
Jean-Michel

In response to

pgadmin-hackers by date

Next:From: Dave PageDate: 2002-02-25 08:42:35
Subject: Re: [ODBC] pgAdmin2 UTF-8 support
Previous:From: Jean-Michel POUREDate: 2002-02-25 08:30:11
Subject: Re: [ODBC] pgAdmin2 UTF-8 support

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group