On 28/05/2004 20:46 Jeff Eckermann wrote:
I had a thought that the ODBC driver could be stripping the trailing spaces, but the test I just did (using MS Access via ODBC) worked fine.
But that's using a different ODBC driver so won't show a possible bug in the PG driver.
Thinking some more, I used a "text" type field for my test. I have some recollection that varchar(n) fields _will_ strip trailing spaces. But I'm too lazy to test that right now.
I was testing using a varchar(n) field.
--
Paul Thomas
+------------------------------+---------------------------------------------+
| Thomas Micro Systems Limited | Software Solutions for Business |
| Computer Consultants | http://www.thomas-micro-systems-ltd.co.uk |
+------------------------------+---------------------------------------------+
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
