Re: trailing spaces on a varchar2 select

From: <afryer_at_my-deja.com>
Date: Thu, 18 Nov 1999 13:58:22 GMT
Message-ID: <8110lr$nlb$1@nnrp1.deja.com>

Found it! The solution is to do an
EXEC SQL VAR svcname IS STRING;
where svcname is the hostvariable that is being selected into. If I don't do that, then I get spaces appened up to the size that the VARCHAR2 is specified as, even if

In article <80u9vi$pt5$1_at_nnrp1.deja.com>, 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.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Nov 18 1999 - 07:58:22 CST