How to insert Unicode letters (Hindi letters) in SQL Server

beginer

1544 Points

52 Posts

I'm using SQL Server DB to store images and name. Following are the table definition:

CREATE TABLE dbo.Tmp_Image
    (
    Id bigint NOT NULL IDENTITY (1, 1),
    Name varchar(250) NOT NULL,
    Url nvarchar(550) NOT NULL,
    Type varchar(150) NOT NULL
    )

And has collation setting as 'Latin1_General_CI_AI'.

I want to store hindi words (for example 'यूनिकोड हिंदी') in the tmp_image.name but it's storing as '???????'.

Views: 2277
Total Answered: 2
Total Marked As Answer: 2
Posted On: 28-Sep-2019 22:57

Share:

Answers

kikme 248 Points 12 Posts	Use nvarchar and correct collations. Reference: http://msdn.microsoft.com/en-us/library/ms144250.aspx https://docs.microsoft.com/en-us/sql/t-sql/data-types/nchar-and-nvarchar-transact-sql?redirectedfrom=MSDN&view=sql-server-2017 Posted On: 01-Oct-2019 10:56
Kjj 30 Points 0 Posts	Use data types supporting Unicode like: nchar nvarchar ntext don't use corresponding data types not supporting Unicode: char, varchar, and text, So, `CREATE TABLE dbo.Tmp_Image ( Id bigint NOT NULL IDENTITY (1, 1), Name nvarchar(250) NOT NULL, Url nvarchar(550) NOT NULL, Type varchar(150) NOT NULL )` Posted On: 02-Oct-2019 00:32 thanks.. - beginer 02-Oct-2019 00:36