> 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