MySQL Forums
Forum List  »  CSV Storage Engine

Re: Issue when export a table to CSV file
Posted by: Jay Alverson
Date: January 31, 2009 06:01PM

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

Options: ReplyQuote

Written By
January 21, 2009 09:59PM
Re: Issue when export a table to CSV file
January 31, 2009 06:01PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.