"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