#1 Can't handle long text fields nor carriage returns

[Anonymous]

I am trying to convert a database in which one of the
tables holds elaborate descriptions of locations.

Access to SQL truncates long texts and doesn't escape
carriage returns.

Example:

INSERT INTO
tarief(id,locatie_id,omschrijving_voor,prijs,omschrijving_na)
VALUES (29,11,"maandagmiddag of vrijdagmiddag",600,"");
INSERT INTO
tarief(id,locatie_id,omschrijving_voor,prijs,omschrijving_na)
VALUES (30,12,"Maandag t/m vrijdag.
Zaterdagochtend: € 369,74.
Maandagochtend om 09.00-09.30",135.79,"");
INSERT INTO
tarief(id,locatie_id,omschrijving_voor,prijs,omschrijving_na)
VALUES (31,12,"Zaterdagochtend",369.74,"");

[Nobody/Anonymous]

Logged In: NO

This report was entered by Philbert.
address: email at philbert dot nl