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