CODEWITHSUNDEEP
c#sql-server-2005
Raghuveera
Raghuveera

Reputation: 320

how to store the Kannada in SQL Server 2005

I want to store Kannada in sql server 2005. I tried to insert via query and baraha direct. that stored as ?????

. Can any one please tell me how i can store Kannada in sql server 2005. i went through the following link they are telling Kannada is not supporting by default. Is it true?.

http://msdn.microsoft.com/en-us/library/ms143508%28v=sql.105%29.aspx

or am i need to set any collation?

Upvotes: 1

Views: 2148

Answers (2)

Aradhya
Aradhya

Reputation: 11

Create the Table column Data type as "NVarchar" into which you need to insert data. If column data type is NVARCHAR then you can insert any Unicode value and it will be stored successfully, but if your column data type was different while inserting data the those unicode values will be stored as '??????'.

Upvotes: 1

vhadalgi
vhadalgi

Reputation: 7189

try this : 

    CREATE TABLE dbo.nammakannada
    ( language NVARCHAR(50)
    , unicodeDa NVARCHAR(200)
    )

    INSERT INTO dbo.nammakannada (language, unicodeDa)
    VALUES
     ('English', N'my example')
    , ('Kannada', N'ಈ ಕನ್ನಡ ಬ್ಲಾಗ್ .')

    SELECT * FROM dbo.nammakannada;
    GO

fiddle_demo

Upvotes: 1

Related Questions