Database Software

Hi,

Now I have a new problem.

I have a Oracle9i instance, with this configurations.

PARAMETER VALUE
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
NLS_CURRENCY $
NLS_ISO_CURRENCY AMERICA
NLS_NUMERIC_CHARACTERS .,
NLS_CHARACTERSET WE8MSWIN1252
NLS_CALENDAR GREGORIAN
NLS_DATE_FORMAT DD-MON-RR
NLS_DATE_LANGUAGE AMERICAN
NLS_SORT BINARY
NLS_TIME_FORMAT HH.MI.SSXFF AM
NLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_TZ_FORMAT HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_TZ_FORMAT DD-MON-RR HH.MI.SSXFF AM TZR
NLS_DUAL_CURRENCY $
NLS_COMP BINARY
NLS_LENGTH_SEMANTICS BYTE
NLS_NCHAR_CONV_EXCP FALSE
NLS_NCHAR_CHARACTERSET AL16UTF16
NLS_RDBMS_VERSION 9.2.0.1.0

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 CLOB field.

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

In order to my xHarbour DOS Client program works fine with this Brazilian accented 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 any client DOS/WINDOWS program like SQLPLUS, SQLDEVELOPER, TOAD, etc, I get bad characters instead the correct Brazilian accented characters.

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 accented characters).

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

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 accented characters).

How to make "SQLPLUS", "TOAD" (and others Windows or DOS Clients programs) show me the Brazilian accented characters correctly?

Thanks in advance,

Luigggye