In this article I will explain how to insert (save) Hindi, Marathi, Gujarati, Urdu, Persian, Arabic, Tamil, Telugu, Chinese (Mandarin) and Japanese languages Text characters in MySql database.
In MySql database we will need to set UTF-8 Collation for the Table to store the various languages text characters.
 
 
Database
For this article I have created a simple table with the following structure. Hindi, Marathi, Gujarati, Urdu, Persian, Arabic, Tamil and Telugu languages Text characters will be saved in the Content column which has a data type VARCHAR.
Insert Hindi, Marathi, Gujarati, Urdu, Persian, Arabic, Tamil, Telugu Chinese and Japanese languages Text characters in MySql Database
 
Note: You can download the database table SQL by clicking the download link below.
          Download SQL file
 
 
Insert Hindi, Marathi, Gujarati, Urdu, Persian, Arabic, Tamil, Telugu Chinese and Japanese languages Text characters in MySql Database
Following are the INSERT statements for inserting different language text characters in MySql database table.
INSERT INTO Languages VALUES('English', 'World is beautiful.');
 
INSERT INTO Languages VALUES('Hindi', 'दुनियासुंदरहै।');
 
INSERT INTO Languages VALUES('Marathi', 'जगसुंदरआहे.');
 
INSERT INTO Languages VALUES('Gujarati', 'વિશ્વસુંદરછે.');
 
INSERT INTO Languages VALUES('Urdu', 'دنیا خوبصورت ہے.');
 
INSERT INTO Languages VALUES('Persian', 'جهانی زیبا است.');
 
INSERT INTO Languages VALUES('Arabic', 'العالم هو جميل.');
 
INSERT INTO Languages VALUES('Tamil', 'உலகஅழகாகஇருக்கிறது.');
 
INSERT INTO Languages VALUES('Telugu', 'ప్రపంచఅందమైనఉంది.');
 
INSERT INTO Languages VALUES('Chinese', '世界是美麗的。');
 
INSERT INTO Languages VALUES('Japanese', '世界は美しいです。');
 
Insert Hindi, Marathi, Gujarati, Urdu, Persian, Arabic, Tamil, Telugu Chinese and Japanese languages Text characters in MySql Database