I’m getting this error ORA-12704: character set mismatch can you please help me to fix this Answer See whether this helps. I presume that this is your situation: This is your current query: This is what you might try to do – apply the to_char function to a nvarchar2 column: