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 SQL Server database versions 2005, 2008, 2008R2 and 2012.
In SQL Server database we will need to use NVARCHAR data type to store the various regional languages text characters like Indian, Arabic, Persian, Chinese (Mandarin), Japanese, etc.
Database
For this article I have created a simple table with the following structure. Hindi, Marathi, Gujarati, Urdu, Persian, Arabic, Tamil, Telugu, Chinese and Japanese languages Text characters will be saved in the Content column which has a data type NVARCHAR.
![Insert Hindi, Marathi, Gujarati, Urdu, Persian, Arabic, Tamil, Telugu, Chinese and Japanese languages Text characters in SQL Server]()
Note: You can download the database table SQL by clicking the download link below.
Insert Hindi, Marathi, Gujarati, Urdu, Persian, Arabic, Tamil, Telugu, Chinese (Mandarin) and Japanese languages Text characters in SQL Server Database
Following are the INSERT statements for inserting different language text characters in SQL Server database table.
Note: You need to have the N prefix to make SQL Server consider the Text as NVARCHAR.
INSERT INTO Languages VALUES('English', 'World is beautiful.')
INSERT INTO Languages VALUES('Hindi', N'दुनियासुंदरहै।')
INSERT INTO Languages VALUES('Marathi', N'जगसुंदरआहे.')
INSERT INTO Languages VALUES('Gujarati', N'વિશ્વસુંદરછે.')
INSERT INTO Languages VALUES('Urdu', N'دنیا خوبصورت ہے.')
INSERT INTO Languages VALUES('Persian', N'جهانی زیبا است.')
INSERT INTO Languages VALUES('Arabic', N'العالم هو جميل.')
INSERT INTO Languages VALUES('Tamil', N'உலகஅழகாகஇருக்கிறது.')
INSERT INTO Languages VALUES('Telugu', N'ప్రపంచఅందమైనఉంది.')
INSERT INTO Languages VALUES('Chinese', N'世界是美麗的。')
INSERT INTO Languages VALUES('Japanese', N'世界は美しいです。')
![Insert Hindi, Marathi, Gujarati, Urdu, Persian, Arabic, Tamil, Telugu, Chinese and Japanese languages Text characters in SQL Server]()
