Re: BUG #1862: ECPG Connect, host variable trailing blanks - Mailing list pgsql-bugs

From Alvaro Herrera
Subject Re: BUG #1862: ECPG Connect, host variable trailing blanks
Date
Msg-id 20050926212248.GB9678@surnet.cl
Whole thread Raw
In response to Re: BUG #1862: ECPG Connect, host variable trailing blanks  (Jim.Gray@Bull.com)
List pgsql-bugs
On Mon, Sep 26, 2005 at 01:12:40PM -0700, Jim.Gray@Bull.com wrote:
> >If Oracle strips trailing spaces on the client side, is that a
> >configurable option?  How would you insert significant trailing
> >spaces into a VARCHAR column if the client library strips them?
>
> The Oracle precompiler (PROC) has an option:   CHAR_MAP=CHARZ
> that allows retaining cobol's trailing blanks.

That's because the Oracle precompiler doesn't ship with the source code,
so if you want the feature you can't just hack it up.  That's not the
case with Postgres -- you have the source, so you can change it if you
want.  More power to you!

--
Alvaro Herrera                         Architect, http://www.EnterpriseDB.com
"Changing the world ... one keyboard at a time!"
                         (www.DVzine.org)

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #1907: problem with function return as integer[]
Next
From: "CN"
Date:
Subject: Can not build libpq.dll with BCC