Re: Issue when export a table to CSV file

[Jay Alverson]

Tough one.

How many records ?

If it's only a few, then you could try transforming the character into something else, run your export then switch back, but if you don't have the means that can
be tough to do.

UPDATE table SET field1 = replace(field1, "\n", char(164));      # ¤ <-- this char = 164 #

Or try something else you prefer.

Obviously make a backup of the data (or a subset of it) and do some testing,
both on the converting, exporting and re-converting "outside" of MySQL.

>

Thanks, Jay