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.

Please share your ideas and opinions about this topic with me, your contribution will add true value to this topic.
If anyone has doubts on this topic then please do let me know by leaving comments or send me an email.

If you like this post, then please share it with others.
Please follow dbrnd.com, I will share my experience towards the success of Database Research and Development Activity.

I put up a post every day, please keep reading and learning.
Discover Yourself, Happy Blogging !
Anvesh M. Patel.

More from dbrnd.com

Leave a Reply

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

Notify of
Sort by:   newest | oldest | most voted

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.