X-Original-To: pgsql-docs-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 42A9ED1B21B; Tue, 18 May 2004 12:29:03 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 56367-02; Tue, 18 May 2004 12:28:37 -0300 (ADT) Received: from mailrelay2.lrz-muenchen.de (mailrelay2.lrz-muenchen.de [129.187.254.102]) by svr1.postgresql.org (Postfix) with ESMTP id 82B65D1CA9D; Tue, 18 May 2004 12:27:38 -0300 (ADT) Received: from webmail.lrz-muenchen.de ([129.187.254.85] [129.187.254.85]) by mailout.lrz-muenchen.de; Tue, 18 May 2004 17:27:36 +0200 Received: from hydra1.fw.med.uni-muenchen.de ([138.245.10.1]) (SquirrelMail authenticated user tum37462) by webmail.lrz-muenchen.de with HTTP; Tue, 18 May 2004 17:27:34 +0200 (MEST) Message-Id: <47181.138.245.10.1.1084894054.squirrel@webmail.lrz-muenchen.de> Date: Tue, 18 May 2004 17:27:34 +0200 (MEST) Subject: PostgreSQL delete the blank in the end of the String automatically. how can I avoid it? From: rong.xie@stud.tu-muenchen.de To: pgsql-docs@postgresql.org Cc: pgsql-general@postgresql.org User-Agent: SquirrelMail/1.4.0 MIME-Version: 1.0 Content-Type: text/plain;charset=iso-8859-1 X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.3 tagged_above=0.0 required=5.0 tests=NO_REAL_NAME X-Spam-Level: X-Archive-Number: 200405/18 X-Sequence-Number: 2393 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? How can convert TIFF Raw G3 to TIFF G4(image file format) in shell script of linux. I hope I can get your Help! Thank you very much! best regards! rong