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

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.