This discussion is archived
5 Replies Latest reply: Sep 24, 2012 12:01 AM by Zoltan Kecskemethy RSS

Problem with special characters

toki79 Newbie
Currently Being Moderated
Hi,

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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points