Storing Arabic and Chinese fonts in SQL Server

This blog helps you to store Arabic and Chinese fonts in the Database.

For storing Arabic and Chinese fonts in Sql Server, your tables want unichar support.

for that create the columns in Table and make sure that it's data type like nvarchar,ntext and nchar

by this way you can store different languages fonts in Sql Server Database.

For Ex:

CREATE TABLE MyTable(CompanyName NVARCHAR(100),Sex NCHAR(2),CompDesc NTEXT)

Now you can store Chinese and Arabic type fonts in this table.

For inserting records in Chinese or Arabic  write this:

INSERT INTO MyTable (CompanyName,Sex,CompDesc) VALUES (N'Some text in Arabic/Chinese',N'Some text in Arabic/Chinese',N'Some text in Arabic/Chinese' )

For inserting  records  in English write this:

INSERT INTO MyTable (CompanyName,Sex,CompDesc) VALUES ('MCN Solutions','M','MCN Solutions is a rapidly growing IT company focused on delivering the best and most cost-effective solutions for Software Development.' )

By this way you can store multi language records in a single table.