Mysql problem with Line Breaks

[J]

In my database, I have some line breaks in certain fields. Everytime I try to import into mysql, it fails because of the line breaks...

What type of line breaks work in FM and can be imported into mysql?

Also, how can I find these line breaks and replace while in FM?

Thanks for your help.

[Wim Decorte]

First you'd need to find the mySQL documention on what line breaks it supports.

Then look in the exported file with a hex editor to see what the characters are (they should ascii 10 - vertical tab) if I'm not mistaken).

Then find a way of changing those *after* the export from FM.

FM does not allow returns in exported text because a line feed/carraiage return character signals the end of the record. That's why FM internally replaces then with VTs before exporting.