Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

How to Store and Retrive the Non English (some other language) Characters in Database. Expand / Collapse
Posted Friday, July 4, 2008 3:09 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, June 1, 2009 5:02 AM
Points: 5, Visits: 10
Hey Guys

I want to store and retrieve the Non English Characters (some other language) in the Database. What i know is while storing it gets stored in the UNICODE format in nvarchar and nchar datatypes. I dont have any idea apart from this.

Can somebody help me in this. If somebody can give me step by step explanation of this then it would be of great help.

Post #528556
Posted Monday, July 7, 2008 6:33 AM



Group: General Forum Members
Last Login: Monday, April 25, 2016 1:53 AM
Points: 416, Visits: 620
Hi Sumit,

You are right to insert a character other than english you need to declare the column as nvarchar and while inserting the data also use N infront of the data to inform SQL Server as unique character. An example is shown below, here im inserting russian character
CREATE TABLE #tmp(description NVARCHAR(15))
INSERT #tmp VALUES (N'Добро')


(1 row(s) affected)

I hope this would hel you!

Regards..Vidhya Sagar
Post #529205
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse