Re: unicode and libpq - Mailing list pgsql-interfaces

From Christoph Haller
Subject Re: unicode and libpq
Date
Msg-id 3F2FC75F.572CC891@rodos.fzk.de
Whole thread Raw
In response to unicode and libpq  (Daniel Brozek <dzemik@venco.com.pl>)
List pgsql-interfaces
>
> How can I put an UNICODE string with characters which code numbers I
> know, ie. "0x00e9 0x00f1"? When I put that string to SQL query,
> interpeter stops with the first 0x00 code. Any ideas? I have trying
with
> UNICODE and LATIN2 client_encoding.
>
From the subject of your message I assume you're using libpq.
Within libpq you cannot deal with strings containing '\0' resp. 0x00
without processing them through PQescapeBytea.

See
1.3.3. Escaping binary strings for inclusion in SQL queries

HTH

Regards, Christoph




pgsql-interfaces by date:

Previous
From: "Alastair G. Hogge"
Date:
Subject: Re: Seeking PyGreSQL help
Next
From: Frank van Vugt
Date:
Subject: Re: Multi-threaded user app segfaults when using libpq with separate connections