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)