I have Oracle 12.2 server on a Linux box.
On the server box, I did the followings in sqlplus:
So everything looks good, I think the reason that US7ASCII can display the name with accents is because both server and the client (sqlplus) use US7ASCII, no conversion was done.
But when I move to Toad (version 13.3 on a Windows 10 laptop), same select gave me:
agr�cola - Spanish word for agricultural
universit� - Italian word for university
Sall� - a 19th century French taxonomist
S�o Paulo - Portuguese, Brazil's largest city
Adam B�ving - a Danish entomologist who worked in the USA
What I need to do make Toad display the same thing sqlplus was showing?
Thank you very much!