From: Christoph Haller <ch@rodos.fzk.de>
To: pgsql-interfaces@postgresql.org
To: dzemik@venco.com.pl
Subject: Re: unicode and libpq
Date: Tue, 05 Aug 2003 17:03:59 +0200
Message-ID: <3F2FC75F.572CC891@rodos.fzk.de> (raw)
>
> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: ch@rodos.fzk.de, dzemik@venco.com.pl
Subject: Re: unicode and libpq
In-Reply-To: <3F2FC75F.572CC891@rodos.fzk.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox