I have a csv
File in that few columns are containing Chinese words,
I am uploading the csv file in Mysql Table using Query:
LOAD DATA local INFILE '/CsvFile.csv' INTO TABLE mytableName FIELDS TERMINATED BY ',' ENCLOSED BY '"' ESCAPED BY '\\' LINES TERMINATED BY '\n' IGNORE 1 LINES
after upload the Chinese characters are getting change into ????????
in mysql
table.
why this is happening? and is there any solution.
Thanks:)