Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Trailing Spaces on VARCHAR2 Data

Trailing Spaces on VARCHAR2 Data

From: Gene Hubert <110530.717_at_CompuServe.COM>
Date: Fri, 11 Dec 1998 17:25:27 -0500
Message-ID: <#HnNoUVJ#GA.204@nih2naab.prod2.compuserve.com> 





I'm running Oracle 8.0.3 on NT 4.0.





I occasionally run across data in varchar2 columns that has 
trailing spaces.  Comparisons on this data will fail without an 
rtrim or adding the right number of spaces to what is being 
compared.  Can anyone explain how varchar2 data ends up with 
trailing spaces?  I thouhgt this was not possbile.



Gene Hubert


Qualex Inc.


Durham, NC



Received on Fri Dec 11 1998 - 16:25:27 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US