Re: PostgreSQL delete the blank in the end of the String automatically. how can I avoid it? - Mailing list pgsql-general

From Paul Thomas
Subject Re: PostgreSQL delete the blank in the end of the String automatically. how can I avoid it?
Date
Msg-id 20040529095856.A16618@bacon
Whole thread Raw
In response to Re: PostgreSQL delete the blank in the end of the String automatically. how can I avoid it?  (Jeff Eckermann <jeff_eckermann@yahoo.com>)
Responses Re: PostgreSQL delete the blank in the end of the String automatically. how can I avoid it?
List pgsql-general
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   |
+------------------------------+---------------------------------------------+

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: turn WAL off.
Next
From: Michal Táborský
Date:
Subject: Use arrays to store multilanguage texts