topic ArcGIS Server REST Accent Insensitive! in ArcGIS REST APIs and Services Questions

ArcGIS Server REST Accent Insensitive!

YgorThomaz — Wed, 06 Oct 2010 18:34:07 GMT

Hello,

How can i make a consult in my ArcGIS REST Services and become the querys Accent Insensitive.

Example:

Where = "COLUMN like Ã¢RCGÃs"

return of the query:

arcgis
ArcgIS
Ã¢rcgÃs

Thank's!

Re: ArcGIS Server REST Accent Insensitive!

ChrisSmith — Wed, 06 Oct 2010 19:10:35 GMT

I assume you can set this up when you specify your database collation, since the rest api runs valid sql statements then I assume it will be reliant on the database to handle the accent insensitive queries.

Maybe you can pass the following in the rest where clause...
http://stackoverflow.com/questions/507504/accent-and-case-insensitive-collate-equivalent-in-oracle

regards

chris

Re: ArcGIS Server REST Accent Insensitive!

YgorThomaz — Wed, 06 Oct 2010 19:36:51 GMT

Chris,

In the Oracle i don't have problem for do it. In our case it's used consults(queries) REST and not PL/SQL Oracle statement.

Remember, all consults(queries) in the ArcGIS Server are made for REST services.

So, i need of a statement or config(ArcGIS Server or application) for searching Accent Insensitive in services REST.

Thanks! (:

Re: ArcGIS Server REST Accent Insensitive!

ChrisSmith — Wed, 06 Oct 2010 20:20:52 GMT

Hi

I dont quite understand what you mean by 'consults', can you give a bit more info

regards

chris

Re: ArcGIS Server REST Accent Insensitive!

ChrisSmith — Wed, 06 Oct 2010 20:23:24 GMT

which also suggest I might not be the right person to answer your question 😄

regards

chris

Re: ArcGIS Server REST Accent Insensitive!

YgorThomaz — Wed, 06 Oct 2010 20:26:29 GMT

consults = queries

(:

Re: ArcGIS Server REST Accent Insensitive!

ChrisSmith — Wed, 06 Oct 2010 21:07:29 GMT

ah yes you were quite clear in the previous post, would have helped if I actually read it properly - LOL

the Rest api suggests any legal SQL statement is valid in the where clause for a Rest Query - I assume that excludes adding an NLSSORT directly in the where clause?

When you run the PL/SQL statement do you specify anything in your query to make it accent insensitive or has this been setup in the init parameters file

been a couple of years since I last used Oracle so will bow out now and leave it to someone with a bit more knowledge and access to an actual Oracle instance 🙂

good luck!

chris