Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Author
Message
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.

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


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, August 19, 2014 1:31 PM
Points: 416, Visits: 573
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'Добро')

SELECT * FROM #tmp
description
---------------
Добро

(1 row(s) affected)

I hope this would hel you!


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

Add to briefcase

Permissions Expand / Collapse