title: Losing newline characters when saving Java string to Oracle CLOB field
body: <p>I'm building a java string and adding newline characters ("\n") where I want to indicate the end of a record. I was storing this string in oracle in a VARCHAR2 field and everything was working just fine until the data I was storing grew too large for such a field. I now am trying to save the records in a CLOB, but when I retrieve the records the newline is missing.</p>
  
  <p>How can I make sure that when I retrieve the data the newlines are still there?</p>
  
  <p>I'd love to add code examples, but I'm working with an API that abstracts the database layer so I'm not exactly certain what it's doing. All I know is it worked when it was saving as a VARCHAR2 but as a CLOB it's gone.</p>