problem in selecting some cells of table

Question

1.00/5 (1 vote)

See more:

SQL-Server-2008

, +

hi friends.

when i run a query in sql server with this command some wonderfull error appear.that it is-->

my command is this "select Kala_Unit from Kala_Table where Kala_Name='kala_Name in persian language'. for some rows that is correct and for some of them it do not return any cell.

please help me. i do not know what to do. thanks alot

Posted 22-Mar-14 21:18pm

_Starbug_

Add a Solution

Comments

CoderPanda 23-Mar-14 3:22am

What do you exactly mean by "some of them it do not return any cell"?
Can you paste sample data from the result please?

_Starbug_ 23-Mar-14 3:33am

my table have 4 rows with 10 column. i want to select column 10 when when user enter column1. in entering some cells of column1 command execution return column10 and for some of them it did not. table information is in persian letter.

_Starbug_ 23-Mar-14 3:37am

i have a table with 4 rows and 10 columns. i want to select column10 when user enter column1. for some rows command executes successfully(it return column 10) but for some of them it did not. and it did not return any thing. table information is persian.

CoderPanda 23-Mar-14 3:45am

Sorry, it's not clear to me at all.

_Starbug_ 23-Mar-14 4:07am

what is the problem in this queries. first query return value but second query does not.
first query:
select Kala_Vahed from Kala_Table where Kala_Name = 'سرپوش';
second query:
select Kala_Vahed from Kala_Table where Kala_Name = 'شیلنگ ظرفشویی';

what i must do? please help

1 solution

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)

Maciej Los · Accepted Answer · 2014-03-23T12:38:00

Solution 1

Not much information to post exact answer. Please, read all comments!

I quess, that Kala_Name is varchar data type. Change it to nvarchar data type[^].

Please refer this: Problem Search In SQL Collation Persian[^]

Posted 23-Mar-14 12:38pm

Maciej Los

Comments

_Starbug_ 25-Mar-14 5:42am

thank you.solved

Maciej Los 25-Mar-14 8:49am

You're welcome ;)
Please, mark this answer as a solution (green button) and vote-up ;)