Re: newline characters in VARCHAR2
From: John Jones <john_at_iluvatar.tip.duke.edu>
Date: 1995/08/02
Message-ID: <Pine.NXT.3.90.950802123317.11002A-100000_at_iluvatar>#1/1
Date: 1995/08/02
Message-ID: <Pine.NXT.3.90.950802123317.11002A-100000_at_iluvatar>#1/1
Not sure how you are getting your data in, it was unclear of in your message, so I hope this will help. We converted from FoxPro to Oracle and the FoxPro memo fields had CR/LF's. In order to SQL*Load them, we had to first convert to some character that you know you would not see in regular data. We used the ALT-152 character. We then SQL*Loaded the file and then converted back to char(10)char(13) which is the CR/LF. It now displays in formatted form.
John Jones | my views are my own......... Oracle Consultant | no matter what company they are john_at_iluvatar.tip.duke.edu | coming from.Received on Wed Aug 02 1995 - 00:00:00 CEST
--------------------------------------------------------------------