Re: PostgreSQL delete the blank in the end of the String - Mailing list pgsql-general

From xier@in.tum.de
Subject Re: PostgreSQL delete the blank in the end of the String
Date
Msg-id 62364.129.187.254.13.1085759781.squirrel@129.187.254.13
Whole thread Raw
In response to PostgreSQL delete the blank in the end of the String automatically. how can I avoid it?  (xier@in.tum.de)
List pgsql-general
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
>
>



pgsql-general by date:

Previous
From: Yannick LOUVET
Date:
Subject: Re: Problem with sequences on a reload of a pg_dump file
Next
From: Manuel Sugawara
Date:
Subject: Re: [NOVICE] PostgreSQL delete the blank in the end of the String automatically. how can I avoid it?