Importing a VARCHAR with newlines

[Mandu]

I'm using mySQL ODBC to import a table into Filemaker. Some of the strings contain newline characters ('n'), and they don't import properly -- I'm not sure whether they're translated into blanks, deleted entirely, or what, but they don't they don't survive as newlines.

I can use mySQL functions to translate this character into something that works, but - what will work?

Thanks,

Chap

[Mandu]

What works: 'r' (works for both Mac and Windows)