Обсуждение: unicode and libpq

Hello,

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.

-- 
Daniel

>
> 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