Blue Theme Orange Theme Green Theme Red Theme
 
Nevron Chart
Home | Forums | Videos | Advertise | Certifications | Downloads | Blogs | Interviews | Jobs | Beginners | Training
 | Consulting  
Submit an Article Submit a Blog 
Search :       Advanced Search »
Home » Blogs Home » Blog Detail

Storing Arabic and Chinese fonts in SQL Server

 by Manish Dwivedi on Sep 01, 2010

This blog helps you to store Arabic and Chinese fonts in the Database.
Comments: 1 Views: 3490 Printable Version 
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.
Comment Request!
Thank you for reading this post. Please post your feedback, question, or comments about this post Here.
 
What do you say about this post? Post a comment here
*Title:
*Comment:
 

Thanks by mohamed ali On Feb 20, 2011
Thanks about ur post it's very helpful for me

DevExpress Free UI Controls
Become a Sponsor

 Blogger's Profile
Age: 30
Location:
Title: DBA
Joined: Apr 10, 2007
Education: Masters Degree
 More Blogs from this Blogger
Get top 10 records from dataset
Split Comma-Separated Strings into Sql Server
ASP.Net Menu Control problem in Chrome
Vertical Split in VS 2010
XML data type in SQL Server
Enable xp_cmdshell in Sql Server 2008
Drop Linked Server IN Sql Server
Storing Arabic and Chinese fonts in SQL Server
Prevent closing of Ajax ModalPopupExtender on postback
Disable Right Click on Web Page in ASP.NET
View all »
 Latest Blogs
Manipulating Huge Integers In C#
Implement Synchronization in Application State Using ASP.NET
Unable to update the EntitySet Table because it has a DefiningQuery and no InsertFunction element exists in the ModificationFunctionMapping element to support the current operation
Transaction Isolation - Part 7 [Serializable Isolation]
Transaction Isolation - Part 6 [Repeatable Read]
Metadata Exception in Entity Framework Connection Strings
Sending any value from one form to another form in WPF
Dealing with Database Reader to avoid errors when DB has null value
How to use multiple checked items from the CheckedListBox?
HTML 5 brings slow death to Silverlight and Flash
View all »
 Latest Jobs
More ... 
 Latest Interview Questions
More ... 
6 Months Free & No Setup Fees ASP.NET Hosting!
 © 2012  contents copyright of their authors. Rest everything copyright Mindcracker. All rights reserved.