Post reply

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

  • July 4, 2008 at 3:09 am

    #122315

    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

  • July 7, 2008 at 6:33 am

    #838795

    [font="Verdana"]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![/font]

    Regards..Vidhya Sagar
    SQL-Articles

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply