8 Replies Latest reply: Jan 3, 2012 6:22 AM by 620922 RSS

    Change Column from LONG to CLOB - blanks inserted

    620922
      We're planning to upgrade three columns (in different tables) from LONG to CLOB. This works fine in two tables, but the third one (it is an XML-string) shows a blank after each character...
      Before (LONG):
      <INVOICE><ID_CONTRACT>000000</ID_CONTRACT><ID_VEHCONTRACT>0000</ID_VEHCONTRACT>
      After (CLOB):
      < I N V O I C E > < I D _ C O N T R A C T > 0 0 0 0 0 0 < / I D _ C O N T R A C T > < I D _ V E H C O N T R A C T > 0 0 0 0 < / I D _ V E H C O N T R A C T >

      Oracle 11.2.0.1.0

      Any ideas? Thanks in advance!