CODEWITHSUNDEEP
oracle-database
Thomas Carlton
Thomas Carlton

Reputation: 5968

How to escape special characters in Oracle?

I have the following string that I'm trying to convert to UTF-8:

Naïve file

I tried to convert it using Oracle:

UTL_URL.ESCAPE('Naïve file')

This returns Na%EFve%20file.

According to this converter, the result should be: Na%C3%AFve%20file, which is what I'm expecting.

How can I fix that?

Upvotes: 2

Views: 627

Answers (1)

Wernfried Domscheit
Wernfried Domscheit

Reputation: 59456

Default character in UTL_URL.ESCAPE set is ISO-8859-1.

Try UTL_URL.ESCAPE('Naïve file', TRUE, 'UTF-8')

Upvotes: 3

Related Questions