Skip site navigation (1) Skip section navigation (2)

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

From: xier(at)in(dot)tum(dot)de
To: vancel(at)winfreeacademy(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: PostgreSQL delete the blank in the end of the String
Date: 2004-05-28 15:56:21
Message-ID: 62364.129.187.254.13.1085759781.squirrel@129.187.254.13 (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-novicepgsql-odbc
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
>
>



In response to

pgsql-novice by date

Next:From: Manuel SugawaraDate: 2004-05-28 15:58:44
Subject: Re: [NOVICE] PostgreSQL delete the blank in the end of the String automatically. how can I avoid it?
Previous:From: Paul ThomasDate: 2004-05-28 13:39:20
Subject: Re: PostgreSQL delete the blank in the end of the String automatically. how can I avoid it?

pgsql-odbc by date

Next:From: Manuel SugawaraDate: 2004-05-28 15:58:44
Subject: Re: [NOVICE] PostgreSQL delete the blank in the end of the String automatically. how can I avoid it?
Previous:From: Paul ThomasDate: 2004-05-28 13:39:20
Subject: Re: PostgreSQL delete the blank in the end of the String automatically. how can I avoid it?

pgsql-general by date

Next:From: Manuel SugawaraDate: 2004-05-28 15:58:44
Subject: Re: [NOVICE] PostgreSQL delete the blank in the end of the String automatically. how can I avoid it?
Previous:From: Yannick LOUVETDate: 2004-05-28 15:22:35
Subject: Re: Problem with sequences on a reload of a pg_dump file

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group