Re: Oracle database configuration options
From: woowoo <woiccak_at_acts-testing.com>
Date: 1996/10/25
Message-ID: <3270b873.3941337_at_news.buffnet.net>#1/1
Received on Fri Oct 25 1996 - 00:00:00 CEST
Date: 1996/10/25
Message-ID: <3270b873.3941337_at_news.buffnet.net>#1/1
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, NYhttp://www.acts-testing.com
Received on Fri Oct 25 1996 - 00:00:00 CEST