agora inbox for pgsql-interfaces@postgresql.org
help / color / mirror / Atom feedFrom: Tom Lane <tgl@sss.pgh.pa.us>
To: CN <cnliou9@fastmail.fm>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: libpq - characterset encoding error from selecting BYTEA
Date: Tue, 15 Mar 2016 09:57:11 -0400
Message-ID: <18018.1458050231@sss.pgh.pa.us> (raw)
In-Reply-To: <1458049871.2074609.549741642.32C1352A@webmail.messagingengine.com>
References: <1458049871.2074609.549741642.32C1352A@webmail.messagingengine.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-interfaces>
CN <cnliou9@fastmail.fm> writes:
> PGconn* first switches to "BIG5" client encoding:
> PQexec(conn,"SET CLIENT_ENCODING TO BIG5");
> version 1:
> const char *pValues[]={"5","6"};
> PGresult *r=PQexecParams(conn,"SELECT c3::BYTEA FROM t1 WHERE c1=$1 AND
> c2=$2",2,NULL,pValues,NULL,NULL,1);
> What is strange is that above PQexecParams() works in one portion of my
> program but in another portion it yields the following error:
> ERROR: character with byte sequence 0x98 0xe1 in encoding "BIG5" has no
> equivalent in encoding "UTF8"
Given the way the complaint is phrased, the problem is with data going
*to* the server, not *from* the server. I don't think the returned bytea
is your issue at all; it must be either in the SQL query string or the
parameter values being sent. Probably you should review how you're
setting up the parameter strings.
regards, tom lane
--
Sent via pgsql-interfaces mailing list (pgsql-interfaces@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-interfaces
view thread (3+ messages) latest in thread
Message-ID: <18018.1458050231@sss.pgh.pa.us>
Permalink: ../18018.1458050231@sss.pgh.pa.us/
Also on: postgresql.org/message-id/18018.1458050231@sss.pgh.pa.us
reply
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: tgl@sss.pgh.pa.us, cnliou9@fastmail.fm
Subject: Re: libpq - characterset encoding error from selecting BYTEA
In-Reply-To: <18018.1458050231@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox