Re: Spaces in Oracle fields

From: Kim Ng <kimmng_at_pebbles.uswnvg.com>
Date: 8 Dec 1994 21:36:10 GMT
Message-ID: <3c7u8a$3mn_at_fred.uswnvg.com>

In ORACLE version 6, ORACLE does not store trailing blanks. In version 7, if you don't want blanks or trailing blanks, use VARCHAR or VARCHAR2 instead. This is the long term solution.

As to the leading blanks, if you don't want it, either set up a batch job to go through the tables and do the update like some of the suggestions ou've gotten (yuck!) or (in version 7) use before insert and before update database triggers or tell your users not to do that (fat chance!).

Hope this helps.

---

 (Whatever I say and own are mine, mine and only mine! So, don't you dare   claim they are yours!)
 Kim Ng
 Paradigm Computer Consulting, Inc.
 20611 E Bothell-Everett Hwy SE, Suite 280  Bothell, WA 98012
 U.S.A. Received on Thu Dec 08 1994 - 22:36:10 CET