hi
there is table in database that has Type column this column saved data in persian language...
I use belwo Store procedure to bind dropdown list ....
as
begin
select Distinct Type
from Estate_Info
where Type=@Type1 or Type=@Type2 or Type=@Type3 or Type=@Type4 or Type=@Type5 or Type=@Type6
or Type=@Type7 or Type=@Type8 or Type=@Type9 or Type=@Type10
order by Type asc
end
here SP doesn't worked correctly and it doesn't show some data in dropdownlist beacuse of persian data...
I had this problem in other Store procedure but when I used "N" it solved:
(Transfer=@Transfer OR @Transfer = N'همه')
now how I can solve this problem for Store procedure
Best regards
neda