The following bug has been logged online:

Bug reference:      5483
Logged by:          Pascal Van Puymbroeck
Email address:      p...@zenonpro.be
PostgreSQL version: 8.3.5 and 8.3.8
Operating system:   Centos 5.4
Description:        PQescapeStringConn behaviour ??
Details: 

Don't know whether this bug/behaviour is normal or fixed in newer versions. 
Didn't have the time to prepare a new installation just to test this.

PQescapeStringConn is intended to facilitate the insertion of say a
streetname with a single quote like " d'alembert ".  Using this function on
normal en special strings like " tëxt " (an e with two dots on, quite
common in the dutch and french language) is no problem.

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 !

-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

Reply via email to