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

beginer

Member

1328 Points

43 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: 2116
Total Answered: 2
Total Marked As Answer: 2
Posted On: 28-Sep-2019 22:57

Share:

Answers

kikme Member 210 Points 10 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 Member 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