PostgreSQL delete the blank in the end of the Stringautomatically. how can I avoid it?

#1

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

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly

#2

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

Quote:

xier (AT) in (DOT) 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

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

#3

xier (AT) in (DOT) tum.de writes:

Quote:

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.

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

PostgreSQL delete the blank in the end of the Stringautomatically. how can I avoid it?

comp.databases.postgresql.novice comp.databases.postgresql.novice

PostgreSQL delete the blank in the end of the Stringautomatically. how can I avoid it? - 05-28-2004 , 07:04 AM

Re: [GENERAL] PostgreSQL delete the blank in the end of the String - 05-28-2004 , 10:56 AM

Re: PostgreSQL delete the blank in the end of the String automatically. how can I avoid it? - 05-28-2004 , 10:58 AM