My Oracle Support Banner

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 to [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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.