SQL Server: Insert different Symbol or Multilingual data in a Table

In this post, I am going to show that how we can insert symbols or multilingual data in the Table of SQL Server.

One of our team member was trying to insert different language data like, Gujarat, Panjabi and tried to insert in VARCHAR column. But unfortunately he found some ‘???? ??’ into that column.

Here, It is a small sample:

The Result:

SQLServerDifferent Language Data

The Solution is NVARCHAR column:
First, you convert VARCHAR your column to NVARCHAR column and put N’ before any special text.

The Final Result:

SQL Server Different Language Data
You can find now, multilingual data is stored in that column.

Anvesh Patel

Leave a Reply

1 Comment on "SQL Server: Insert different Symbol or Multilingual data in a Table"

Notify of
avatar
Sort by:   newest | oldest | most voted
Fermin
Guest

We’re a group of volunteers and opening a new scheme in our community.
Your web site offered us with valuable information to work
on. You’ve done an impressive job and our whole community
will be thankful to you.

wpDiscuz