NLS_COMP and NLS_SORT Initialization Paramaters

Posted on 2006-03-28
Last Modified: 2012-05-05
I have tried setting the initialization parameters in the SPFile for NLS_COMP=ansi and NLS_SORT=binary_ci.  I apply and recycle the server and the parameters are set.  However, when I perform a query from SQLPLUS, the database is still case sensitive.  If I do SHOW PARAMETER NLS_COMP, the proper values are set.  I can run ALTER SESSIONS and set the parameters to get the query to be case insensitive, but that is not ideal.

I am running Oracle 10gR2.

Question by:BrianG
    1 Comment
    LVL 16

    Accepted Solution

    I would think that it would work if the sessions showt that. run this and see what it shows...
    select * from nls_session_parameters where parameter in ('NLS_COMP','NLS_SORT');
    to assure they really are set in the session.

    If they aren't it sounds like it miht be a bug of some sort, but I'm not sure what all can affect a session logging in like that. I'm primarily a developer.

    At a minimum, to fix this, you could use a login trigger. I use these quite a lot now to assure that the nls parameters are the way I want them and also for setting the schema and I've been using an application context so I set that there too. Anyway, I suspect you already new this... running the alter session in a login trigger is probably the easiest fix... if not a complete answer.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
    This post first appeared at Oracleinaction  ( Anju Garg (Myself). I  will demonstrate that undo for DML’s is stored both in undo tablespace and online redo logs. Then, we will analyze the reaso…
    This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…
    This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now