Query task issue with Arabic input

Question

I am using ArcGIS Java Script API version 2.8 & using query layer in ArcGIS server.

The data is coming from sql server and most of the data is in Arabic language. I am sorting the data and according to the particular map is displaying.

I have created the query task and result will be displaying in combo-box but when I select Arabic record then the map is displaying blank if I select English record then its displaying correctly. For details Please check the screen shot.

The column type is “nvarchar” in sql server and in query task I am using where condition as follows But still getting an error

query.where = "STATE <> N''" (In sql server query works if I use N'')

What I tried:

1.Changed the query parameter. 2.It works perfect for English names. 3.Added UTF 8 encoding. 4.Upgraded API to 3.2 (latest one) 5.In Sql server where query works successfully.

Still getting an error...Any help will be great!!! thanks in advance : )

@All

I confirmed through REST API and through API I was able to query to the data base. Please check the new screen-shots

So as far as the logic the the information is coming but why its not displaying on the map (its interesting) also I have check parameters in the map service & Still researching..

Answer 1

I was able to find the answer and thanks a lot Simon for your important points/guidelines

I have attached JS fiddle with this and I have changed the following things 1.In query task I used query.where = "1=1"; 2. On line no 275 I have inserted "N" for varchar data type and it works successfully!! layerDefs[0] = "STATE = " + "N'" + selItem.value + "'";

3.The complete JS Fiddle is here ( Only I have changed the server name)

Thanks again to Simon : )