Failed 6706 The string contains an untranslatable character

Database
Fan

Failed 6706 The string contains an untranslatable character

when I run

select upper('i');

then result is; 'I', but I want to get 'İ'

and I ran

select lower('İ'); I get the error

Failed 6706 The string contains an untranslatable character.

in oracle sql it is not a problem 

What can I do to fix this problem?

thank you.

(the database is UTF8)

1 REPLY
Enthusiast

Re: Failed 6706 The string contains an untranslatable character

Try casting it exclusively to unicode and then applying lower function.