Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: trailing spaces on a varchar2 select

Re: trailing spaces on a varchar2 select

From: Pete Sharman <psharman_at_us.oracle.com>
Date: Wed, 17 Nov 1999 09:23:42 -0800
Message-ID: <3832E49E.4AD6CE91@us.oracle.com>


Oracle does this for char datatypes, which are fixed length, not for varchar2.

Pete

afryer_at_my-deja.com wrote:

> I'm using embedded SQL to select a varchar2 datatype from a table. We
> are using Oracle7.3.4. The problem is that Oracle seems to append
> spaces up to the size that the varchar2 datatype is defined as for the
> table. Is there some way I can stop Oracle appending spaces onto the
> returned value?
>
> Thanks,
>
> Anthony
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.


Received on Wed Nov 17 1999 - 11:23:42 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US