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

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

From: Manuel Sugawara <masm(at)fciencias(dot)unam(dot)mx>
To: xier(at)in(dot)tum(dot)de
Cc: pgsql-novice(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org,pgsql-odbc(at)postgresql(dot)org
Subject: Re: [NOVICE] PostgreSQL delete the blank in the end of the String automatically. how can I avoid it?
Date: 2004-05-28 15:58:44
Message-ID: m3k6yw35mz.fsf@conexa.fciencias.unam.mx (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-novicepgsql-odbc
xier(at)in(dot)tum(dot)de writes:

> 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?

Let me guess, the offending column's type is char(x), right?. If
that's the case you must change it to something else, varchar or text.

Regards,
Manuel.

In response to

pgsql-novice by date

Next:From: Alain-Serge NagniDate: 2004-05-28 16:06:29
Subject: Postgresql Novice problem
Previous:From: xierDate: 2004-05-28 15:56:21
Subject: Re: PostgreSQL delete the blank in the end of the String

pgsql-odbc by date

Next: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?
Previous:From: xierDate: 2004-05-28 15:56:21
Subject: Re: PostgreSQL delete the blank in the end of the String

pgsql-general by date

Next:From: Rory Campbell-LangeDate: 2004-05-28 17:01:02
Subject: Re: ERROR: date/time field value out of range: "28/05/2004 02:15:57"
Previous:From: xierDate: 2004-05-28 15:56:21
Subject: Re: PostgreSQL delete the blank in the end of the String

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