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

From Manuel Sugawara
Subject Re: [NOVICE] PostgreSQL delete the blank in the end of the String automatically. how can I avoid it?
Date
Msg-id m3k6yw35mz.fsf@conexa.fciencias.unam.mx
Whole thread Raw
In response to PostgreSQL delete the blank in the end of the String automatically. how can I avoid it?  (xier@in.tum.de)
List pgsql-general
xier@in.tum.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.

pgsql-general by date:

Previous
From: xier@in.tum.de
Date:
Subject: Re: PostgreSQL delete the blank in the end of the String
Next
From: Rory Campbell-Lange
Date:
Subject: Re: ERROR: date/time field value out of range: "28/05/2004 02:15:57"