SIGN UP MEMBER LOGIN:    
Blog

Storing Arabic and Chinese fonts in SQL Server

Posted by Manish Dwivedi Blogs | SQL Server 2012 Sep 01, 2010
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.
share this blog :
post comment
 

Thanks about ur post it's very helpful for me

Posted by mohamed ali Feb 20, 2011