sql*loader for French characters

 Hi,

Im use 10.2.0.3 and try to load a xml into a clob column. The XML has some french characters.

After load into  the table, we get some special characters in the table that are not match the original ones in the file. Can anyone help to load this correctly?

Here is a example:

--original characters:
la possibilité

-- after load into table:
offrir la possibilit¿e

Below are all the info:

--table
desc T_TEMP_CLOB;
 Name                                      Null?    Type
 ----------------------------------------- -------- ------------------
 LOB_FILE                                           VARCHAR2(128)
 LOB_DATA                                           CLOB

--control file clob_loader.ctl
load data
CHARACTERSET UTF8 ( also tried UTF16 which didn't even load the data to database)