pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: John DeSoi <desoi@pgedit.com>
To: Joel Fradkin <jfradkin@wazagua.com>
Cc: aarni@kymi.com
Cc: pgsql-sql@postgresql.org
Subject: Re:  RE: [SQL] trrouble inserting stuff like é
Date: Fri, 18 Feb 2005 15:42:24 -0500
Message-ID: <986DAB00-81ED-11D9-9C09-000A95B03262@pgedit.com> (raw)
In-Reply-To: <000001c515d5$01adc570$797ba8c0@jfradkin>
References: <000001c515d5$01adc570$797ba8c0@jfradkin>


On Feb 18, 2005, at 11:15 AM, Joel Fradkin wrote:

> How do I tell the connection to use Unicode?

Try

SET client_encoding TO 'UNICODE';

http://www.postgresql.org/docs/8.0/interactive/sql-set.html

But it should default to the database encoding, so I'm not sure if that 
is the problem.


John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL




view thread (7+ messages)  latest in thread

Message-ID: <986DAB00-81ED-11D9-9C09-000A95B03262@pgedit.com>
Permalink:  ../986DAB00-81ED-11D9-9C09-000A95B03262@pgedit.com/
Also on:    postgresql.org/message-id/986DAB00-81ED-11D9-9C09-000A95B03262@pgedit.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: desoi@pgedit.com, jfradkin@wazagua.com, aarni@kymi.com
  Subject: Re:  RE: [SQL] trrouble inserting stuff like é
  In-Reply-To: <986DAB00-81ED-11D9-9C09-000A95B03262@pgedit.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox