title: REPLACE CHR(32) in oracle
body: <p>I have problem here, the record in database ends with no space. the value is EXT:
  but when i select with this query :</p>
  
  <pre><code>SELECT REPLACE(REPLACE(REPLACE(COL_CONTENT,CHR(10),'\n'),CHR(9),'\t'),CHR(32),'\s') FROM TABLE_A;
  </code></pre>
  
  <p>the record become :</p>
  
  <pre><code>+6221\s29023070\sEXT\s:\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s\s
  </code></pre>
  
  <p>Actually in database after EXT: dont have any characters or space. but the record still show so many \s after EXT:</p>