Issue :

Today, I received one request from my old friend.

He wants to insert text in different languages in table. He is looking to create Multilanguage table.

Solution :

The simplest solution is to insert data in table as NVARCHAR data type, like below.

–Create Table

CREATE TABLE TBL_LANG

(

LNAME VARCHAR(50),

LTXT NVARCHAR(100)

)

–Insert “Hello World” in diffrent language

INSERT INTO TBL_LANG

VALUES (‘English’,N’Hello World’)

INSERT INTO TBL_LANG

VALUES (‘Hindi’,N’???? ??????’)

INSERT INTO TBL_LANG

VALUES (‘Chines’,N’????’)

INSERT INTO TBL_LANG

VALUES (‘Urdu’,N’???? ????’)

–View Table data

SELECT * FROM TBL_LANG