Toad € to € symbol Oracle euro UTF-8

Question

I am using Toad 9.0.1.8.

A table in a column was showing a euro € symbol as €

I've tried changing the environment variable NLS_LANG=AMERICAN_AMERICA.AL32UTF8 in my windows machine, I've also tried using American_America.UTF8 and American_America.WE8ISO8859P1, yet it did not get resolved, I'm still seeing the characters but not a euro symbol. Every time i changed the env var, I restarted Toad.

Could somebody help? Tried some solutions by searching online, nothing worked.

Answer 1

Maybe you have a character set issue in you DB? From this thread it seems to be a problem with DB settings.

Also some suggestion on charset issues suggest upgrading to version 10 of Toad if that is an option since it's a unicode release.