Re: MYSQL doesn't 'see' accents

[Evi Wool]

I've looked into this further. The problem is more than I thought.
I used Load Data to import a text file where some of the text contained é. I checked the Notepad file and the accented words displayed correctly in the text file but when the text file was imported, each é was shown Ú, ç was displaced as c, è was displayed as þ
Here's the code I used to load the text file into the table
LOAD DATA LOCAL INFILE 'C:\\TblEnglish.txt'

INTO TABLE TblEnglish
FIELDS TERMINATED BY '\t'
ENCLOSED BY '"'
LINES TERMINATED BY '\r\n'
(EngID, English);

I am able to type these letters correctly in MySQL (using Alt and the number keypad) and UPDATE the records and they display fine so I don't see how mySQL's character set or the VarChar field datatype can be at fault. Is there a command line I need to change in the LOAD DATA code?