Recent changes to 1: Can't handle long text fields nor carriage returnshttps://sourceforge.net/p/access2sql/bugs/1/2006-06-25T15:33:19ZRecent changes to 1: Can't handle long text fields nor carriage returnsCan't handle long text fields nor carriage returns2006-06-25T15:33:19Z2006-06-25T15:33:19ZAnonymoushttps://sourceforge.net/u/userid-None/https://sourceforge.netcc55b59ecc990859253f964c3e4c2b4cf086f271<div class="markdown_content"><p>I am trying to convert a database in which one of the<br />
tables holds elaborate descriptions of locations.</p>
<p>Access to SQL truncates long texts and doesn't escape<br />
carriage returns.</p>
<p>Example:</p>
<p>INSERT INTO<br />
tarief(id,locatie_id,omschrijving_voor,prijs,omschrijving_na)<br />
VALUES (29,11,"maandagmiddag of vrijdagmiddag",600,"");<br />
INSERT INTO<br />
tarief(id,locatie_id,omschrijving_voor,prijs,omschrijving_na)<br />
VALUES (30,12,"Maandag t/m vrijdag.<br />
Zaterdagochtend: € 369,74.<br />
Maandagochtend om 09.00-09.30",135.79,"");<br />
INSERT INTO<br />
tarief(id,locatie_id,omschrijving_voor,prijs,omschrijving_na)<br />
VALUES (31,12,"Zaterdagochtend",369.74,"");</p></div>