0 Replies Latest reply: Feb 17, 2014 6:17 AM by Saxena RSS

    Special Character 'ÿ' converted to '?' while spooling using SQL Plus

    Saxena

      Hi,

       

      I need to spool 'ÿ' (French Language Character set) in my Output file spooled using SPOOL utility of SQL Plus.

       

      But in the spooled output the character 'ÿ' is replaced by '?' .

       

      Kindly let me know how I can avoid this replacement of special characters in my output SPOOL.

       

      SELECT * FROM NLS_DATABASE_PARAMETERS

      where parameter ='NLS_CHARACTERSET'

       

      PARAMETER VALUE
      NLS_CHARACTERSET WE8MSWIN1252

       

      Version info :

      ------------------------------------------------------------------------------------------------------------

      Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

      PL/SQL Release 11.2.0.3.0 - Production

      CORE 11.2.0.3.0 Production

      TNS for Linux: Version 11.2.0.3.0 - Production

      NLSRTL Version 11.2.0.3.0 - Production

       

      Cheers !!

      Saxena