Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




On 28/05/2004 13:04 xier@in.tum.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 |
+------------------------------+---------------------------------------------+


---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux