How to Store and Retrive the Non English (some other language) Characters in Database.

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Administering » How to Store and Retrive the Non English...

How to Store and Retrive the Non English (some other language) Characters in Database.

Rate Topic

Display Mode

Topic Options

Author

Message

sumit.sharma

Posted Friday, July 04, 2008 3:09 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, June 01, 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

vidhya sagar

Posted Monday, July 07, 2008 6:33 AM

SSC-Addicted

Group: General Forum Members
Last Login: Tuesday, March 19, 2013 2:45 AM
Points: 416, Visits: 521

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 »

Permissions