PROBLEM SOLVED
Posted by: Paul Pikowsky
Date: August 23, 2011 10:58AM

The problem is solved.

From your article here:

http://mysql.rjweb.org/doc.php/charcoll

I find the option of "CHARACTER SET" for the LOAD DATA INFILE command. I used "CHARACTER SET utf8" and everything is showing up fine. Here is the command in its entirety:

LOAD DATA LOCAL INFILE  '/tmp/XXXXX.txt' INTO TABLE xxxxx CHARACTER SET utf8 FIELDS TERMINATED BY '**'

I found this clue in the part of your article under "Fixing while moving data with LOAD DATA".

You should give your heading tags IDs in that article so that you can link directly to them and so a link to the article I needed might be http://mysql.rjweb.org/doc.php/charcoll#FixWhile. The tag would looks something like <h2 ID= "FixWhile">Fixing while moving data with LOAD DATA</h2>

Thanks again for your encouraging reply.

Options: ReplyQuote




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.