Re: PostgreSQL delete the blank in the end of the String

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(at)in(dot)tum(dot)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
>
>