Re: Support for unicode - Mailing list pgsql-general

From Carmen Wai
Subject Re: Support for unicode
Date
Msg-id F1449CHXUESFEgoAA9a0000b7ec@hotmail.com
Whole thread Raw
In response to Support for unicode  ("Carmen Wai" <wai_carmen@hotmail.com>)
List pgsql-general
Hello:

Is that mean just treating the unicode characters as multibyte? How about I
insert the unicode data using libpq C library? Do I just insert the unicode
characters normally as character (char * query)??

PGresult *PQexec(PGconn *conn, const char *query);

Thanks for you help!
Carmen

>
>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
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 6: Have you searched our list archives?
>
>http://archives.postgresql.org


_________________________________________________________________
Add photos to your e-mail with MSN 8. Get 2 months FREE*.
http://join.msn.com/?page=features/featuredemail


pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Fw: configure error with krb5
Next
From: Greg Stark
Date:
Subject: Re: point -> double,double ?