Re: NLS_COMP=ANSI and NLS_SORT=GENERIC_BASELETTER

Joshua,

Your session needs to have various NLS_ parameters set, which can be done for the entire database (which is probably not what you want) in your init.ora file, or the individual session can do it using 'alter session' commands. If you cannot modify the application to execute alter session, you can use logon triggers to do the same, but again, these are per database user, and may hence have effect on too many sessions if you only need it for a few sessions.

BTW, sorting has nothing to do with character sets, sorting has to do with locales and is independent of character set.

/Bjørn.

Joshua Becker wrote:

> Hi,
>
> I need to do some sorts with Scandinavian characters and I need to set
> these parameters
>
> NLS_COMP=ANSI and
>
> NLS_SORT=GENERIC_BASELETTER
>
> Where do I put these because I am using and application and WebLogic is
> calling some programns which are actually using that sorts...
>
> Any ideas would be apreciated...
>
> TIA
> Kalle
>
> Gå före i kön och få din sajt värderad på nolltid med Yahoo! Express
> <http://se.docs.yahoo.com/info/express/help/index.html>
>

-- 
Bjørn Engsig, Miracle A/S
Member of Oak Table Network <http://www.oaktable.net>
Bjorn.Engsig@MiracleAS.dk - http://MiracleAS.dk



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: =?ISO-8859-1?Q?Bj=F8rn_Engsig?=
  INET: bjorn_at_miracleas.dk

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).