Get UNICODE data using libpq

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • gouse
    New Member
    • Feb 2007
    • 18

    Get UNICODE data using libpq

    Hi All,

    I am using libpq 'C' interface to connect to the PostgreSQL database. The encoding of Database is UTF8 and it also contains a table with UNICODE data. By using PQconnectdb() I have made a connection with the database, Next I have also set the PGSetClientEnco ding() to UTF8, After this I am executing the select query using PQexec() command, but it was not giving the UNICODE data. Is there any step I am missing?

    By using the ODBC Driver9(UNICODE not ANSI) I made a connection to the same database and executed the same select query, here it was giving me the UNICODE data properly.

    Please let me know how to get the UNICODE data using the libpq Interface.

    Thanks & Regards
    Gouse Shaik
Working...