Re: Oracle database configuration options

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