Thread: PostgreSQL delete the blank in the end of the String automatically. how can I avoid it?
PostgreSQL delete the blank in the end of the String automatically. how can I avoid it?
From
xier@in.tum.de
Date:
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
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 > >
Re: PostgreSQL delete the blank in the end of the String automatically. how can I avoid it?
From
Manuel Sugawara
Date:
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.