Forum Stats

  • 3,826,326 Users
  • 2,260,624 Discussions
  • 7,896,896 Comments

Discussions

[SOLVED] A query with SDO_POINTINPOLYGON returns chinese characters

Paul_6690295
Paul_6690295 Member Posts: 8 Green Ribbon
edited Apr 11, 2022 6:59AM in Database Installation

Hi,

A weird thing is happening. All my settings are in Western European, and this query returns Chinese gibberish, and I can't find the cause (or solution)

Consider this query:

I shortened the length of the ordinate_array for obvious reasons

The result is:

Where do those Chinese characters come from in de columns for NAAM and CODE ?

When I select data from the cursor select from MyTable, I get normal West-European (Dutch) text. So that's not the issue.


My guess is that SDO_POINTINPOLYGON somehow messes things up... but why, and how to fix that ?

Thanks for your ideas and suggestions

Paul.

Tagged:

Best Answer

Answers