I’ve had a problem in querying Persian character (ی"") from oracle database in my client since I reinstall my windows and pl/sql developer.
The character set in my client’s registry is AMERICAN_AMERICA.AR8MSWIN1256.
When I use this query
select * from credit where CTYPE = 'تسهیلات'
it doesn’t match with any record.
But when I change the query to
select * from credit where CTYPE = N'تسهیلات'
It returns matched records.
How could I fix this problem without using “N”, because I should change all my old queries.