5 Replies Latest reply: Sep 24, 2012 2:01 AM by Zoltan Kecskemethy RSS

    Problem with special characters


      special characters are not displayed properly. The NLS Parameters look ok for me, doesn't they?
      SQL> SELECT 'äöüÄÖÜß' FROM dual
      1 row selected.
      SQL> select * from v$nls_parameters
      PARAMETER                                                        VALUE                                                           
      ---------------------------------------------------------------- ----------------------------------------------------------------
      NLS_LANGUAGE                                                     GERMAN                                                          
      NLS_TERRITORY                                                    GERMANY                                                         
      NLS_CURRENCY                                                     €                                                               
      NLS_ISO_CURRENCY                                                 GERMANY                                                         
      NLS_NUMERIC_CHARACTERS                                           ,.                                                              
      NLS_CALENDAR                                                     GREGORIAN                                                       
      NLS_DATE_FORMAT                                                  DD.MM.RR                                                        
      NLS_DATE_LANGUAGE                                                GERMAN                                                          
      NLS_CHARACTERSET                                                 AL32UTF8                                                        
      NLS_SORT                                                         GERMAN                                                          
      NLS_TIME_FORMAT                                                  HH24:MI:SSXFF                                                   
      NLS_TIMESTAMP_FORMAT                                             DD.MM.RR HH24:MI:SSXFF                                          
      NLS_TIME_TZ_FORMAT                                               HH24:MI:SSXFF TZR                                               
      NLS_TIMESTAMP_TZ_FORMAT                                          DD.MM.RR HH24:MI:SSXFF TZR                                      
      NLS_DUAL_CURRENCY                                                €                                                               
      NLS_NCHAR_CHARACTERSET                                           AL16UTF16                                                       
      NLS_COMP                                                         BINARY                                                          
      NLS_LENGTH_SEMANTICS                                             BYTE                                                            
      NLS_NCHAR_CONV_EXCP                                              FALSE                                                           
      19 rows selected.