How to Diagnose Losing Characters , Getting "Funny" Output When Inserting or Selecting Other Than A-Z,a-z ( = Non English Data Like Chinese, Russian, Hebrew , Insert Any Language Here to the List That is Not English) in/from CHAR, VARCHAR2, LONG or CLOB
Last updated on MARCH 08, 2018
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 and later
Oracle Database - Standard Edition - Version 22.214.171.124 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
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms