Re: BUG #5483: PQescapeStringConn behaviour ?? - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #5483: PQescapeStringConn behaviour ??
Date
Msg-id 24389.1275167757@sss.pgh.pa.us
Whole thread Raw
In response to BUG #5483: PQescapeStringConn behaviour ??  ("Pascal Van Puymbroeck" <ppk@zenonpro.be>)
List pgsql-bugs
"Pascal Van Puymbroeck" <ppk@zenonpro.be> writes:
> However if the " ë " character is at the end of a string like the name of a
> country in dutch "Italië"  this PQescapeStringConn function adds two
> spaces.  so "België" becomes "België  ".  The error is set to 1 which
> indicates we can't trust the outcome.  But I don't see why he has a problem
> with that character at the end of the string and not in the middle !

This isn't tremendously surprising if you're feeding data to the
function that is not in the encoding it expects (which is what the error
flag almost certainly is telling you).  It may be able to detect the
problem in some cases and not others.

            regards, tom lane

pgsql-bugs by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: BUG #5469: regexp_matches() has poor behaviour and more poor documentation
Next
From: "Sakari A. Maaranen"
Date:
Subject: Re: BUG #5480: Autovacuum interferes with operations (e.g. truncate) on very large databases