pg.ddx.io pgsql-interfaces@postgresql.org mailing list archivehelp / color / mirror / Atom feed
unicode and libpq 2+ messages / 2 participants [nested] [flat]
* unicode and libpq @ 2003-08-04 17:28 Daniel Brozek <dzemik@venco.com.pl> 0 siblings, 0 replies; 2+ messages in thread From: Daniel Brozek @ 2003-08-04 17:28 UTC (permalink / raw) To: pgsql-interfaces 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: unicode and libpq @ 2003-08-05 15:03 Christoph Haller <ch@rodos.fzk.de> 0 siblings, 0 replies; 2+ messages in thread From: Christoph Haller @ 2003-08-05 15:03 UTC (permalink / raw) To: pgsql-interfaces; dzemik@venco.com.pl > > 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2003-08-05 15:03 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2003-08-04 17:28 unicode and libpq Daniel Brozek <dzemik@venco.com.pl> 2003-08-05 15:03 Re: unicode and libpq Christoph Haller <ch@rodos.fzk.de>
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