PROBLEM SOLVED
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.
Subject
Views
Written By
Posted
5068
August 21, 2011 11:51AM
3128
August 23, 2011 09:04AM
4221
August 23, 2011 10:38AM
PROBLEM SOLVED
2699
August 23, 2011 10:58AM
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.