Last updated on DECEMBER 05, 2016
Applies to:Oracle Database - Enterprise Edition - Version 184.108.40.206 and later
Oracle Database - Standard Edition - Version 220.127.116.11 and later
Information in this document applies to any platform.
***Checked for relevance on 10-Oct-2016***
Trying to select from or insert in CHAR, VARCHAR2, LONG or CLOB datatypes other than A-Z,a-z data ( = non English data like Chinese, French, Russian, Hebrew , insert any language here to the list that is not English or "special characters" like the € symbol) and the result is
- or some form of a question mark like ? , ¿ or �.
- or the data shows up as "funny" characters for example Â¯Â°Â±Â²Â³Â´ÂµÂ¶Â·Â¹ instead of the expected data.
Changes can be many, new client installation, new database installation or simply trying to use a not used language before in an existing system with "normal" CHAR, VARCHAR2, LONG or CLOB column types.
This note provides a step by step approach to find out where the problem is and then how to correct it.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms