when I run
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?
(the database is UTF8)
Try casting it exclusively to unicode and then applying lower function.