Re: Re: bug in Auth (?)
| From: | Jeroen Houben | Date: | Fri, 11 Apr 2003 14:12:34 +0000 |
| Subject: | Re: Re: bug in Auth (?) | ||
| References: | 1 2 | Groups: | php.pear.dev |
| Request: | Send a blank email to pear-dev+get-15116@lists.php.net to get a copy of this message | ||
Martin Jansen wrote:
On Fri, 2003-04-11 at 15:44, Jeroen Houben wrote:http://www.postgresql.com/docs/view.php?version=7.2&idoc=0&file=datatype-character.html HTH - JeroenI'm switching from MySql to PostgreSQL and PEAR::Auth keeps throwing "wrong username and password" at me. After some investigation I found out that postgres returns extra spaces in char fields, the results aren't trimmed. [...] Can you apply this patch, or should I (as the user) just make sure my database returns trimmed results?The patch is ok, but I really would like to know if this behaviour of PostgreSQL is intended. Can you make some checks there? yes, I've done some tests and if I use char, the values get padded, if I use varchar, they don't.