hi, thank you very much for your tips! As your tip: use a char() field instead of a varchar() field. The problem is solved. Thanks! have a good time! rong > 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? >> > If you know how long you need to field to be, use a char() field instead > of a varchar() field or some other varying-length field. If the length > of the fields needs to be variable, then try putting some sort of > termination character at the end of the blank space... such as a period > (.), then have your program strip it out when it's reading it. > >>How can convert TIFF Raw G3 to TIFF G4(image file format) in shell script >>of linux. >> > You can use a program called Image Magick for the image conversion. The > software has several programs that are installed as a result, and it's > all usable via the shell. The specific program that you'll want to read > about is called "convert". A program that I have set up that part of > its function is to create thumbnail pictures uses convert like this: > > convert -geometry 221x164 sourcefile newfile > > Good luck! > >> >>I hope I can get your Help! >>Thank you very much! >> >>best regards! >> >>rong >> >> > -- > Thanks, > Laura Vance > Systems Engineer > Winfree Academy Charter Schools, Data-Business Office > 1711 W. Irving Blvd. Ste 310 > Irving, Tx 75061 > Web: www.winfreeacademy.com > > ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html