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

Home -> Community -> Mailing Lists -> Oracle-L -> Phantom characters

Phantom characters

From: David Barbour <dbarbour_at_connectsouth.com>
Date: Tue, 16 Jan 2001 18:42:54 -0600
Message-Id: <10743.126847@fatcity.com>


Greetings,

I've got some entries in one of my columns that appear to contain a leading space or spaces. When I try to use ltrim, they don't go away. If I spool the data, I find these spaces are actually represented in the spool file as /240. I don't have this number as an ascii, decimal or octal representation of anything, and am at a loss as to how to identify and remove these "phantoms". Any ideas?

David A. Barbour
Oracle DBA - ConnectSouth
512-681-9438
dbarbour_at_connectsouth.com Received on Tue Jan 16 2001 - 18:42:54 CST

Original text of this message

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