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