I also had similar problems with encoding. I'm using libpqxx, and as Ivo
stated, I need do this to get my queries working properly:
work T(C, "my_transaction");
T.exec("SET client_encoding = UTF8");
result R(T.exec("SELECT * FROM my_table_with_portuguese_strings"));
On 8/30/07, Ivo Rossacher <rossacher(at)bluewin(dot)ch> wrote:
> Am Mittwoch, 29. August 2007 08:59 schrieb Korumilli, Bala S (GE
> If the client_encoding is UTF8 you need to confert the strings in your c++
> code to UTF8.
> The other options to adjust the client_encoding to the encoding the client
> machine uses and let the server convert from and to UTF8 for you. This
> your client program require to anlyze the encoding of the system and send
> client_encoding to '<found encoding>'; to the server.
> See chapter 21 in the manual for more details about the issue.
> Best regards
> > But If i write a c++ program using LIBPQ to run this query, I get an
> > of invalid byte sequence like this..
> > ERROR: invalid byte sequence for encoding "UTF8".
> > I also observed the same error comes for all the characters other than
> > ascii(0-127). Is it a limitation of LibPQ library?
> > The follwing information may be helpful to you.
> > DataBase encoding: UTF8.
> > client_encoding: UTF8
> > Postgres version: 8.2.3
> > Can you please tell me what is the reason for this strange behaviour?
> ---------------------------(end of broadcast)---------------------------
> TIP 7: You can help support the PostgreSQL project by donating at
Hilton William Ganzo Perantunes
Sistemas de Informação - Universidade Federal de Santa Catarina
Dinheiro não traz felicidade, mas dá uma sensação tão parecida... -_-
In response to
pgsql-interfaces by date
|Next:||From: Michael Meskes||Date: 2007-09-03 11:09:56|
|Subject: Re: NAN-Values in ECPG-Code|
|Previous:||From: Ivo Rossacher||Date: 2007-08-30 20:57:40|
|Subject: Re: Problem with character encodings.|