Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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 CST