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 parametersNLS_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
KalleGå före i kön och få din sajt värderad på nolltid med Yahoo! Express
