Skip site navigation (1) Skip section navigation (2)

Re: PostgreSQL delete the blank in the end of the String automatically. how can I avoid it?

From: Paul Thomas <paul(at)tmsl(dot)demon(dot)co(dot)uk>
To: "pgsql-general (at) postgresql (dot) org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: PostgreSQL delete the blank in the end of the String automatically. how can I avoid it?
Date: 2004-05-29 08:58:56
Message-ID: 20040529095856.A16618@bacon (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-novicepgsql-odbc
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   |
+------------------------------+---------------------------------------------+

In response to

Responses

pgsql-novice by date

Next:From: Oliver ElphickDate: 2004-05-30 05:39:49
Subject: Re: Copy from problem
Previous:From: Alain-Serge NagniDate: 2004-05-28 20:29:37
Subject: Re: Postgresql Novice problem

pgsql-odbc by date

Next:From: Jeff EckermannDate: 2004-05-30 17:19:23
Subject: Re: PostgreSQL delete the blank in the end of the String automatically. how can I avoid it?
Previous:From: Jeff EckermannDate: 2004-05-28 19:46:06
Subject: Re: PostgreSQL delete the blank in the end of the String automatically. how can I avoid it?

pgsql-general by date

Next:From: Michal TáborskýDate: 2004-05-29 09:31:27
Subject: Use arrays to store multilanguage texts
Previous:From: Tom LaneDate: 2004-05-29 05:17:57
Subject: Re: turn WAL off.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group