How to Remove Special Character from an Unicode String Based on Its Hex Value
(Doc ID 2571104.1)
Last updated on AUGUST 19, 2019
Applies to:PL/SQL - Version 220.127.116.11 to 18.104.22.168 [Release 11.2 to 12.2]
Information in this document applies to any platform.
The purpose of this document is to demonstrate how to identify special/non-printable character, if exists any, in a given unicode string and to eliminate the same using the SQL built-in functions.
For example, the following string has a non-printable character at its end. The existence of the character can be realized when the string is highlighted till its end.
Postpayment postage charge|後納郵便料金
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document