0

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.

Jamie Taylor
  • 4,709
  • 5
  • 44
  • 66
pirategod7
  • 11
  • 1
  • 7

1 Answers1

0

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.

Qben
  • 2,617
  • 2
  • 24
  • 36