Update Oracle Database Connector documentation to include setting environment variable ORA_NCHAR_LITERAL_REPLACE=TRUE in target Oracle DB server #680
novenera
started this conversation in
Feature Ideas/Requests
Replies: 0 comments
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
Uh oh!
There was an error while loading. Please reload this page.
-
My customer is using Logic Apps Standard Oracle connector with OPDG and he came across an issue when reading “national characters” (i.e. those outside of the ASCII character set). They have raised a support ticket to investigate the issue and it has been found that setting environment variable ORA_NCHAR_LITERAL_REPLACE=TRUE on the target Oracle DB server solves the issue. This finding was based on several articles found online:
https://www.appservgrid.com/documentation111/docs/rdbms11gr1/appdev.111/b28843/tdddg_globalization.htm#CIHGJBFI
https://oracle-randolf.blogspot.com/2007/05/national-character-set-and-string.html
The customer has requested if this can be included in our documentation as well so that it could help other customers who may run into the same issue in the future. I would suggest to add it under the known limitations section of the Oracle Database Connector.
Beta Was this translation helpful? Give feedback.
All reactions