On Mon, Sep 26, 2005 at 01:12:40PM -0700, [EMAIL PROTECTED] 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) ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly