Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error "ORA-12704: character set mismatch" in CASE Statement

Greetings,
I have the following problem when using ELSE and I place the field that I want to recover, I get the following error:
image.pngBut if I comment on the ELSE, the sentence works:
image.pngInvestigating use NVARCHAR2 (50) or ELSE N'XXXXX ', but without any successful results.
I look forward to your comments, thank you
This post has been answered by mathguy on Jul 24 2021
Jump to Answer
Comments
Post Details
Added on Jul 23 2021
#sql, #sqldeveloper
3 comments
20,551 views