Re: Oracle database configuration options

From: Halina Monka <toyr002_at_ibm.net>
Date: 1996/10/25
Message-ID: <3270E0B6.20EA_at_ibm.net>#1/1


woowoo wrote:
>
> I am using many char(##) fields in my tables. When data is entered,
> oracle pads the fields with spaces. For example I have a char(20)
> called name. I enter Tom into my powerbuilder data entry form. When
> I look at the data in oracle, Tom with 17 spaces is stored.
>
> My question: Is there any oracle configuration setting to suppress
> this behavior?
>
> BTW, I know that powerbuilder did not pad the data. It's Oracle...
>
> thanks,
> tom
> -------------------------------------------------
> Tom Woiccak ACTS Testing Labs
> woiccak_at_acts-testing.com Buffalo, NY
> http://www.acts-testing.com
> -------------------------------------------------

Use varchar2(20) instead.
Halina Monka Received on Fri Oct 25 1996 - 00:00:00 CEST

Original text of this message