Special characters are changed to question marks
957719Aug 24 2012 — edited Aug 24 2012I'm using SQL developer 3.107 for unit testing.
In a particular unit test, the expected result is a sentence (varchar2) with a special character (ë).
But when I save the result, SQL developer changes the character to 2 question marks.
And as a result, the unit test fails because the expected result differs from the received result (where the 'ë' remains unchanged).
I already tried changing the encoding in the SQL Developer preferences from cp1252 to UNICODE and UTF8 but that didn't help.
Any suggestions?
Thanks in advance