How to make TOAD-ORACLE shows me the Brazilian accented characters correctly?
"Luis_Oliveira_Creative" <[email protected]>
| Newsgroups | gmane.comp.db.oracle.toad.free |
|---|---|
| Message-ID | <[email protected]> |
Hi,
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 TOAD for Oracle, 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 TOAD.
Certifico que por deciso proferida no processo n§ @@@@@@@@@@@@@@,
foi reconhecida a no incidncia do ITBI na transao do(s) im¢vel(is)
abaixo caracterizado(s), com base no art.156, @ 2§, I, da Constituio
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 "TOAD for ORACLE" shows me the Brazilian accented characters correctly?
Thanks in advance,
Luigggye
------------------------------------
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/toad/
<*> Your email settings:
Individual Email | Traditional
<*> To change settings online go to:
http://groups.yahoo.com/group/toad/join
(Yahoo! ID required)
<*> To change settings via email:
[email protected]
[email protected]
<*> To unsubscribe from this group, send an email to:
[email protected]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/