Re: Insert Unicode

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