Re: nlssort problem

MadeOfRose wrote:
> Thank you for well explained answer.
> i use ALTER SESSION statement and it works very well.
> do i have to anything at oracle if i set the NLS_SORT=XTURKISH
> environment variable?
> how does oracle understand the environment variable?

See the globabization guide:
http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14225/ch3globenv.htm#g1012681

You need to remember to export environment variables in unix environments, syntax is dependent on shell. For example, my korn shell would like:

export NLS_SORT=XTURKISH

jg

--
@home.com is bogus.
No room for downtime or error... on commodity systems...
http://www.alphatradefn.com/story/2006-04-26/BIZ/200604260800BIZWIRE_USPR_____BW5201.html