Other Language(Chinese) character chenge in to ??????? Mysql Load Query

88 views Asked by At

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:)

0

There are 0 answers