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-28 13:39:20
Message-ID: 20040528143920.A14794@bacon (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-novicepgsql-odbc
On 28/05/2004 13:04 xier(at)in(dot)tum(dot)de wrote:
> hello,
> 
> my Name is Rong. I am student at TU-Munich. I have some questions for
> Postgresql7.2  under SuSe Linux.
> Postgresql7.2  under SuSe Linux8.0.
> I use PostgreSQL7.2 with PGAdminII1.4.2 under Windows2000.
> 
> I insert a String from Teleform6.0 of Cardiff through ODBC in table of
> PostgreSQL.
> There should be some blank in the End of the String. e.g: "data
>      "
> But there ist no blank in the end of the String in the table. e.g: "data"
> It means, that PostgreSQL delete the blank in the end of the String
> automatically.
> But I need the blank in the end of the String.
> how can I avoid it?

AFAICT, it's not PostgreSQL which is causing your problem. I've just 
tested against 7.2.1 using psql and it does _not_ remove trailing spaces. 
I think your problem is with your client code.

HTH

BTW, 7.2 is very old. I'd recommend upgrading.

-- 
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: xierDate: 2004-05-28 15:56:21
Subject: Re: PostgreSQL delete the blank in the end of the String
Previous:From: xierDate: 2004-05-28 12:04:56
Subject: PostgreSQL delete the blank in the end of the String automatically. how can I avoid it?

pgsql-odbc by date

Next:From: xierDate: 2004-05-28 15:56:21
Subject: Re: PostgreSQL delete the blank in the end of the String
Previous:From: xierDate: 2004-05-28 12:04:56
Subject: PostgreSQL delete the blank in the end of the String automatically. how can I avoid it?

pgsql-general by date

Next:From: Yannick LOUVETDate: 2004-05-28 15:22:35
Subject: Re: Problem with sequences on a reload of a pg_dump file
Previous:From: Rory Campbell-LangeDate: 2004-05-28 13:27:23
Subject: Re: ERROR: date/time field value out of range: "28/05/2004 02:15:57"

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