Toad World® Forums

Dirty character for db with W8ISO8859P1 characterset


Hi all in my db NLS_CHARACTERSET=W8ISO8859P1.

in TOAD i see dirty characters, i have created ENV_Variable with name NLS_LANG=“AMERICAN_AMERICA.AR8MSWIN1256” and also i have setted this in WINDOWS registry,but it didn’t change dirty characters. how can i solve problem? please guide me !



As far as I know, you should be able to see the characters correctly without doing anything special. Does your Windows version match your database character set?

Remove the NLS env variable and try again.

Are you sure that these “dirty” characters are correctly stored on the database?



I have removed NLS Env variable, but problem persists.

other applications view data’s fine (PLSQLDEVELOPER and HORA).