1 Reply Latest reply: Jul 25, 2012 9:26 PM by Sergiusz Wolicki-Oracle RSS

    How to make "SQLPLUS" show me the Brazilian accented characters correctly?

    883679
      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 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

      Edited by: 880676 on Jul 20, 2012 9:08 PM