Re: Oracle database configuration options

woowoo wrote:
>
> On Thu, 24 Oct 1996 19:16:52 GMT, woiccak_at_acts-testing.com (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 all. Got my answer. Boy, do I feel stupid! Using varchar(##)
> instead of char(##) is the solution. I now remember that from my
> Informix days...
>
> -------------------------------------------------
> Tom Woiccak ACTS Testing Labs
> woiccak_at_acts-testing.com Buffalo, NY
> http://www.acts-testing.com
> -------------------------------------------------

Hallo, Tom,

you should use VARCHAR2(##), because the type of VARCHAR(##) is not defined by now.
It could be changed in further releases.

Oliver
(This is my own and personal oppinion) Received on Tue Oct 29 1996 - 00:00:00 CET