Latin character not accepted into DB
Latin character not accepted into DB
I am using a Oracle DB which is configured for NLS_CHARCTERSET = 'US7ASCII' and hence it doesn't accepts UTF8 compliant.
Got to know a work around that we can use UNISTR() function to convert strings into desired characters. But, though I was able to see the output as '§' for following query:
SELECT UNISTR('0a7') FROM DUAL;
I was unable to insert that character into a column in the table whose type is VARCHAR2. I am seeing output as '?' after I try to insert that character. Can someone help me with that ?
NVARCHAR2
VARCHAR2
What if you insert the '007' and when extracting use UNISTR().
– D.J.
Sep 14 '18 at 14:33
@MT0: It worked for me. Thanks a ton!
– iSVK
Oct 11 '18 at 15:09
0
Thanks for contributing an answer to Stack Overflow!
But avoid …
To learn more, see our tips on writing great answers.
Required, but never shown
Required, but never shown
By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.
Use an
NVARCHAR2data type instead ofVARCHAR2?– MT0
Sep 13 '18 at 21:41