This discussion is archived
0 Replies Latest reply: Apr 22, 2013 11:44 AM by GeospatialMarty RSS

how to query for foreign encoded text via REST service

GeospatialMarty Newbie
Currently Being Moderated
I am using APEX 4.2.1.00.08 to publish RESTful web services that query a table of place names. The place names include foreign encoded alternates. My search field has type of NVARCHAR2 and the db has NLS_CHARACTERSET of AL32UTF8. Querying for foreign encoded names works fine from other applications (e.g. TOAD, ArcGIS).

In APEX under 'SQL Workshop | RESTful Services' I have created a module, resource template, and resource handler. When I use 'Set Bind Variables' to test the service, it works for 'English' names with no problem (e.g. 'London').

However, when I query for a foreign equivalents like 'ロンドン', the Japanese version of 'London', I get the following error:

400 - Bad Request
The request path contains illegal characters

How do I get foreign encoded place names to work as the bind variable value of a REST service?

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points