Toad World® Forums

How to make "TOAD for ORACLE" shows me the Brazilian accented characters

Hi,

I have a Oracle9i instance, with this configurations.

http://www.screencast.com/t/EbBkz0sTtn

I have a xHarbour DOS Client program that reads, shows in the screen, and write"perfectly fine" a text with Brazilian accentuation stored in a CLOBfield.

Following you can see the sample of the text with Brazilian accentuation in myDOS application http://www.screencast.com/t/U5PXwCEo8

In order to my xHarbour DOS Client program works fine with this Brazilianaccented characters, I must to set:

SET NLS_LANG=PORTUGUESE_BRAZIL.WE8MSWIN1252

And all is OK from my xHarbour DOS Client program.

My problem is because when I query this data manually using a SELECT from TOADfor Oracle, I get bad characters instead the correct Brazilian accentedcharacters.

Following you can see the same text into the Toad http://www.screencast.com/t/A1tal2Rtg

(you will see bad characters instead the correct Brazilian accentedcharacters).

Following you can see the result of querying this field using a SELECT fromTOAD.

Certifico que por decis„o proferida no processo n§ @@@@@@@@@@@@@@,
foi reconhecida a n„o incidˆncia do ITBI na transa‡„o do(s) im¢vel(is)
abaixo caracterizado(s), com base no art.156, @ 2§, I, da Constitui‡„o
Federal de 1988 e no art.6§, II, da Lei Municipal n§ 1.364 de 19/12/1988.

(you will see bad characters instead the correct Brazilian accentedcharacters).

How to make “TOAD for ORACLE” shows me the Brazilian accentedcharacters correctly?

Thanks in advance,

Luigggye

Hi there,
If needed, our award-winning Support team can help (phone and link below). We here on the Development team also monitor our Yahoo groups daily, and we hope to see you there.

YAHOO GROUP:
http://tech.groups.yahoo.com/group/toad/

SUPPORT:
https://support.quest.com/Default.aspx

Support can be emailed at:
Support@Quest.com

Support can be reached by phone at:
1.800.306.9329 or 949.754.8000