decimal separator identify/query

[HugoAhlenius]

Hi, I am working on a web application, and the server is ArcGIS 10.1.

Now I just noticed something very funny - when I do query tasks everything works as it should, but for an identify task, the server returns comma as the decimal separator. The server is located in Norway, and I haven't investigated it further (and experimented) but it is likely that the user account that the server is running under is set to Norwegian regional settings. Setting the user to en-us probably fixes this...

I did some troubleshooting, and I could see the comma-decimal separator in the requests - see the json returned from this query for instance: http://bit.ly/Sxbynh. Note the shape.area attribute/field for instance.

[__Rich_]

SQL Server is not sensitive to the regional settings.

Are you applying that statement to all of SQL Server?

[HugoAhlenius]

It was as I thought - I changed the regional settings of the arcgis account on the server, and then the request looks as I expected it. So MSSQL had nothing to do with the thing, nor the locale setting on the client (as obvious in the REST request). The URL in the first post is no longer relevant, that shows the expected decimal separator now.

[__Rich_]

So MSSQL had nothing to do with the thing

Just to be clear, I wasn't implying that the locale of the DBMS was definitely affecting your results, just that it does have an effect in some circumstances.  (e.g. can depend on the settings/functionality of the client library used to connect to the DBMS)

Glad you've found a workaround for your issue, let's hope that ESRI can 'align' the various REST methods to be consistant in how they return data. 🙂

[HugoAhlenius]

Too bad it is convoluted for me to log a bug (I would have to do it through my national reseller, and then it doesn't feel worth it). I was hoping that someone from the mothership would post in the thread...

[__Rich_]

Too bad it is convoluted for me to log a bug (I would have to do it through my national reseller, and then it doesn't feel worth it). I was hoping that someone from the mothership would post in the thread...

I have an issue logged with Support concerning the inconsistency in date format from the REST methods - will post if I hear anything back...although I raised it nearly 2 months ago and it's been logged in Nimbus for 1 month so I'm not too hopeful of an answer.

Also, since it's server-side, you may get a more 'direct line' to the appropriate ESRI people via http://forums.arcgis.com/forums/11-ArcGIS-Server-(10.0-and-prior)-REST-API