PostgreSQL SQL - convert with libpq

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

convert with libpq

lms

2006-11-16, 7:16 pm

Hi

I must convert some records from database.
I have table named "langset" in unicode database. When I try use command

select convert((SELECT "1" from langset where id_langset=5) using
utf_8_to_iso_8859_2)

in PGadmin, all is ok, sql return 1 record. But where i execute the same
command in libpq I got 0 rows:

res=PQexec(conn_loka
lne,"select convert((SELECT \"1\" from langset where
id_langset=5) using utf_8_to_iso_8859_2)
");

printf("%s" ,PQgetvalue(res,0,0)
);

What is the problem?

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Sponsored Links