| From: | Björn Metzdorf <bm(at)turtle-entertainment(dot)de> |
|---|---|
| To: | "Carmen Wai" <wai_carmen(at)hotmail(dot)com>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Support for unicode |
| Date: | 2003-01-16 14:06:57 |
| Message-ID: | 019801c2bd68$883e7c00$81c206d4@office.turtleentertainment.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruno Wolff III | 2003-01-16 14:44:23 | Re: three timestamps/table, use of 'now' in table creation statement |
| Previous Message | Carmen Wai | 2003-01-16 13:38:24 | Support for unicode |