Problem to insert arabic words in SQL server

Question

1.00/5 (2 votes)

See more:

problem to insert arabic text as sql variable in sql server 2008 inserts data like this value ???? .How to solve this?

This is my query

insert into tests values(N''+@name)

What I have tried:

I tried to add N' different types in the query.But I can't solve this.

Posted 16-May-17 3:41am

Member 11086281

Updated 23-Mar-21 0:42am

Add a Solution

Comments

Richard MacCutchan 16-May-17 10:13am

There is no problem inserting words in any language: data is data and has no meaning until it is displayed to a human. You just need to ensure that when you select it out of the database you use the correct culture and fonts to display it.

Member 11086281 16-May-17 10:18am

This is my query.

declare @name nvarchar(50);
set @name='محسن';
insert into tests values(N''+@name)

But It saves as ???? in table

ZurdoDev 16-May-17 10:34am

Is the field NVARCHAR?

Member 11086281 17-May-17 0:09am

yes

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Mehdi Gholam · Accepted Answer · 2017-05-16T04:38:00

Solution 1

The N prefix only works on the actual string not a copy of it so:

SQL

declare @name nvarchar(50);
set @name = N'محسن';
insert into tests values(@name)

Posted 16-May-17 4:38am

Mehdi Gholam

Comments

Afzaal Ahmad Zeeshan 16-May-17 10:42am

5ed.

Mehdi Gholam 16-May-17 11:20am

Cheers!

Maciej Los 16-May-17 14:00pm

It couldn't be so easy... :laugh:

Mehdi Gholam 16-May-17 23:43pm

:)

Member 11086281 17-May-17 0:09am

friends.I am sending @name variable from my c# code to stored procedure.So I can't set value to the variable like above.
How to use N' in that variable?

Mehdi Gholam 17-May-17 0:14am

Then check the collation on your database and change it if needed : http://www.serverintellect.com/support/sqlserver/change-database-collation/

Member 11086281 17-May-17 0:26am

@Mehdi Gholam: Issue solved using the above link .Thank you brother.Thank you all for helping me.

Member 11086281 · Accepted Answer · 2017-05-16T18:36:00

Solution 2

Issue solved using this link http://www.serverintellect.com/support/sqlserver/change-database-collation [^] suggested by Mehdi Gholam

Posted 16-May-17 18:36pm

Member 11086281

Updated 16-May-17 22:07pm

v3

Comments

PIEBALDconsult 17-May-17 0:43am

Please don't answer your own question. Just use Improve question to add detail and context.

Member 11086281 17-May-17 1:20am

ok