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

Поиск
Список
Период
Сортировка
От xier@in.tum.de
Тема Re: PostgreSQL delete the blank in the end of the String
Дата
Msg-id 62364.129.187.254.13.1085759781.squirrel@129.187.254.13
обсуждение исходный текст
Ответ на PostgreSQL delete the blank in the end of the String automatically. how can I avoid it?  (xier@in.tum.de)
Список 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 по дате отправления:

Предыдущее
От: Yannick LOUVET
Дата:
Сообщение: Re: Problem with sequences on a reload of a pg_dump file
Следующее
От: Manuel Sugawara
Дата:
Сообщение: Re: [NOVICE] PostgreSQL delete the blank in the end of the String automatically. how can I avoid it?