The following bug has been logged online:
Bug reference: 5907
Logged by: Andrew Considine
Email address: Andrew.Considine@sncorp.com
PostgreSQL version: 9.0.1-1
Operating system: Windows XP
Description: ODBC % bug
Details:
Using a password that contains a "%" symbol does not authenticate while
using the ODBC driver. The Postgresql installer accepts this password. The
password will even work while logging into PGAdmin. However when connecting
through the ODBC driver from one of our C++ applications we receive the
following error: FATAL: password authentication failed for user
"<username>". We tested this behaviour with the "%" symbol in various
positions of the password with the same result. Also, we tested this with
"^" which worked as it should and "&" which also worked as it should. It
was only the usage of the "%" that failed to work properly while
authenticatin via the ODBC driver.