Database Administration (MOSC)

MOSC Banner

PROBLEM WITH NLS_SORT AND NLS_COMP

edited Mar 5, 2009 3:29AM in Database Administration (MOSC) 2 commentsAnswered
 Hello,
I have a problem with the parameters NLS_SORT and NLS_COMP.

When I started the session these are my parameters:

select PARAMETER, VALUE
FROM NLS_SESSION_PARAMETERS
WHERE PARAMETER IN ('NLS_LANGUAGE', 'NLS_COMP', 'NLS_SORT', 'NLS_TERRITORY')

PARAMETER,VALUE
-------------------- --------------------
NLS_LANGUAGE, SPANISH
NLS_TERRITORY, SPAIN
NLS_SORT, SPANISH
NLS_COMP, BINARY

With these parameters, I ran the following query and it works:

SELECT      pieza_serie.pnr,  
            pieza_serie.c_otan_fab,  
            pieza_serie.sn,  
            pieza_serie.iec,  
            pieza_serie.var_edc,  
            pieza_serie.c_pos_edc,  
            pieza_serie.f_ult_ubic,
            pieza_serie.f_cum_vida,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center