Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

[SOLVED] A query with SDO_POINTINPOLYGON returns chinese characters

Paul_6690295Apr 10 2022 — edited Apr 11 2022

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:
image.pngI shortened the length of the ordinate_array for obvious reasons
The result is:
image.pngWhere 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.
image.png
My guess is that SDO_POINTINPOLYGON somehow messes things up... but why, and how to fix that ?
Thanks for your ideas and suggestions
Paul.

This post has been answered by Paul_6690295 on Apr 11 2022
Jump to Answer

Comments

Post Details

Added on Apr 10 2022
1 comment
97 views