importing excel file(chinese char) to mysql

[ramesh kumar]

i am using 5.0.45 DOS based.

i tried to import excel file to mysql table in the following method. (excel is having english letters & chinese letters also.)

1. save excel file as .csv( comma delimeter)
2. in Mysql type the commands,
set names utf8;

3. in mysql, i used the following coomand

LOAD DATA LOCAL INFILE 'c:/test.csv' INTO TABLE test_table
FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n';

after that i used select * from test_table command. the data are displayed as "????" or machine codes.

what is the wrong? or any orther method is there? pl help me.


thanks
ramesh