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. ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend