MySQL Forums
Forum List  »  Newbie

LOAD DATA INFILE - French character being replaced
Posted by: Christian Hamel
Date: July 21, 2005 08:15AM

Hello everyone,
I'm sorry to post this question since it seems that there's already a lot question regarding the same topic on the net and I've tried a few things and none works. So before considering committing suicide, I decided to ask here ;)

I have a text file that contains strings and some have french character (é è à ê etc...). I've created a simple table with two (2) character fields; a code and a description. By looking at the text file, I can see the french character. Once loaded using the command:

LOAD DATA INFILE 'C:/Datafiles/In_Sous_Inv.TXT'
INTO TABLE In_Sous_Inv
(In_Type_Sous, In_Description_Sous);

I loose the french characters. As an example I should have a value "Séparateur" but it is "S0parateur"

I've change my charset on my table to be CHARSET=latin1 Collate=latin1_bin and reloaded my table, without success.. Any help would be greatly appreciated.

Environment:
MySQL 5.0ß on Windows 2003 Server (English) W/SP1

Options: ReplyQuote


Subject
Written By
Posted
LOAD DATA INFILE - French character being replaced
July 21, 2005 08:15AM


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.