Home Forums SQL Server 2005 Administering How to Store and Retrive the Non English (some other language) Characters in Database. RE: How to Store and Retrive the Non English (some other language) Characters in Database.

  • [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]