Data handling during exports

------=_NextPart_000_0053_01CA904B.9CFE2A10
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

Good day all...



I have some questions regarding data handling when doing
exports in mysql.



This is a follow up on my mails yesterday about the exports
within a cron.





What we found now was places where the users for instance
manually entered a "\" in a field and the export then carries the next field
over to a new line thus causing problems with the imports as it is seen as a
new line and the amounts of fields do not correspond to the table.



The second thing we found was that one of the fields is a
varchar(255) field. However when we count the characters in the field
(exported file) there are 257 characters in the field. This includes
spaces,etc...





Any ideas on how this can happen or how to resolve?

Your assistance will be appreciated.



Regards

Machiel






------=_NextPart_000_0053_01CA904B.9CFE2A10--