Missing line feed character while reading and writing to a different table or log file
<p>My goal is to read the <code>varchar2</code> (4000 byte) value and </p>

<ul>
<li>set it another <code>varchar2</code> (byte) field without losing the format (new line feeds).</li>
<li>write it to the log file without losing the format</li>
</ul>

<p>value is stored in the database fine.  When I go to Toad, copy and print it to Notepad, I can see the formatted text with new line feed.</p>

<p>But when I read it from the database using Java, <code>resultset.getString()</code>, and write it to log file or set to a different field, I am missing the format (missing the line feed char).  </p>

<p>When I read it as <code>resultset.getCharacterStream()</code>, I can see <code>chr(10)</code> in the bytes array.</p>

<p>What is the best way to read it and write to database or log file without losing the format?</p>
