Load csv file to a MySql database

LOAD DATA INFILE command is used to load the file's data to the database. 

Retrieve other language character from the MySQL database?

Recently, I surfaced a problem while printing the Japanese / Chinese scripts which I retrieve from the database.

ERROR 1022 (23000)

I came across an error in MySQL when I tried to transfer the data from a remote database to my local database.