Re: BUG #1862: ECPG Connect, host variable trailing blanks

From: Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>
To: Jim(dot)Gray(at)Bull(dot)com
Cc: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Ken(dot)Rosensteel(at)Bull(dot)com, pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1862: ECPG Connect, host variable trailing blanks
Date: 2005-09-26 21:22:48
Message-ID: 20050926212248.GB9678@surnet.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Mon, Sep 26, 2005 at 01:12:40PM -0700, Jim(dot)Gray(at)Bull(dot)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)

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message CN 2005-09-27 07:35:14 Can not build libpq.dll with BCC
Previous Message Jim.Gray 2005-09-26 20:12:40 Re: BUG #1862: ECPG Connect, host variable trailing blanks