PROBLEM SOLVED

[Paul Pikowsky]

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.