Re: Support for unicode - Mailing list pgsql-general

From Björn Metzdorf
Subject Re: Support for unicode
Date
Msg-id 019801c2bd68$883e7c00$81c206d4@office.turtleentertainment.de
Whole thread Raw
In response to Support for unicode  ("Carmen Wai" <wai_carmen@hotmail.com>)
List pgsql-general
> Do any one know how to input unicode data into the postgreSQL database
> through the PostgreSQL client API? Are there any special API which support
> the wide characters??

Have a look at http://www.postgresql.org/idocs/index.php?multibyte.html

What you can do is transform your characters properly to UTF-8 and then
insert them as normal having server and client encoding set to UNICODE.

What you can also do: Don't transform them to UTF-8, but set your
client_encoding to desired value (see the link above) and use the automatic
encoding translation between server and client. They will be automagically
translated to UNICODE (UTF-8).

Regards,
Bjoern



pgsql-general by date:

Previous
From: "Carmen Wai"
Date:
Subject: Support for unicode
Next
From: Bruno Wolff III
Date:
Subject: Re: three timestamps/table, use of 'now' in table creation statement