Re: Insert Unicode - Mailing list pgsql-general

From Tino Wildenhain
Subject Re: Insert Unicode
Date
Msg-id 13445283.1018971038@buzzer
Whole thread Raw
In response to Insert Unicode  ("Anthony" <anthonykwok@writeme.com>)
List pgsql-general
Hi,

--On Dienstag, 16. April 2002 14:23 +0800 Anthony <anthonykwok@writeme.com>
wrote:

> Hi all,
>
> I have created a UNICODE database using the 7.2.1. But I am not sure how
> to prepare an insert script to insert double byte unicode data (e.g.
> Chinese) to the tables. I tried to run the script under PGAdminII and
> also psql directly but always encounter problem say invalid UNICODe. Any
> escape character required?

If you run the database unicode, the default encoding is utf-8.
So either prepare your imports with that encoding or
switch the frontend-encoding with
set client_encoding to 'your-encoding-here'

Regards
Tino

pgsql-general by date:

Previous
From: Moritz Sinn
Date:
Subject: Re: function for creating random id
Next
From: Fernando Schapachnik
Date:
Subject: Compiling libpgtcl.dll