Re: Oracle database configuration options

From: suvas <suvas_at_pacific.net.sg>
Date: 1996/10/25
Message-ID: <01bbc2fa$23b508e0$df5678cb@Singnet.singnet.com.sg>#1/1

char datatype always blank pads.Use Varchar2 or if u still insist on char use trim functions
when retreiving.

woowoo <woiccak_at_acts-testing.com> wrote in article <326fbcb4.23929213_at_news.buffnet.net>...
> 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
> -------------------------------------------------
>
Received on Fri Oct 25 1996 - 00:00:00 CDT