How to insert a line break in a SQL Server
<p>I have a <code>java</code> apps.</p>

<p>I insert some text into <code>sql server database</code></p>

<p><strong><em>java:</em></strong></p>

<pre><code>courriel.setTxtCouContenu(corps);
</code></pre>

<p>When i inspect my var <code>corps</code> i have this:</p>

<p><a href="https://i.stack.imgur.com/qSe8i.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/qSe8i.png" alt="enter image description here"></a></p>

<p>You can see <code>\r\n</code></p>

<p>So when i look in my database there is not  line break.</p>

<p>My insert statement (iBatis):</p>

<pre><code>&lt;statement id="insert"
    parameterClass="test.business.bo.TestBO"
    resultClass="java.math.BigDecimal"&gt;
    INSERT INTO dbo.E_COUR (ID, CORPS,)
    VALUES (#testBO.id:Numeric#,
    #corps:Varchar#)
    SELECT SCOPE_IDENTITY()
    AS value
&lt;/statement&gt;
</code></pre>