选择一些桌子的细胞的问题 [英] problem in selecting some cells of table

问题描述

朋友们。



当我在sql server中使用此命令运行查询时会出现一些奇怪的错误。这是 - >



我的命令是从Kala_Table中选择Kala_Unit，其中Kala_Name ='kala_Name用波斯语'。对于某些行是正确的，对于其中一些行，它不返回任何单元格。



请帮帮我。我不知道该怎么办。非常感谢

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

推荐答案

发布信息不多确切的答案。请阅读所有评论！



我问， Kala_Name 是varchar数据类型。更改它 nvarchar数据类型 [ ^ ]。



请参考：< a href =http://social.msdn.microsoft.com/Forums/sqlserver/en-US/1630de68-d7ef-4781-827f-0eb87d605db8/problem-search-in-sql-colla ing-persian？forum = sqldatabaseengine> SQL Collat​​ion Persian中的问题搜索 [ ^ ]

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[^]

这篇关于选择一些桌子的细胞的问题的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！