nlssort problem

hi all

i have got a problem about nlssort statement.

i use oracle 10g r2 (32 bit on amd64) with windows 2003 server r2 (32 bit)
we have special characters in turkish (i dont know you can see correctly.they are;öÖçÇiIsSüÜgG)

i create a database with windows 1254 character set(8 bit) which supports these special character. But, when i use select with ordey by keyword then the words which start with turkish character show up at the bottom of the results.

After that i invent the nlssort :P(i guess it is a function).it works when use it like below

select * from GECOUST order by NLSSORT(ad,'NLS_SORT=XTURKISH')

it seem ok.But,i also see a usage at documents of oracle.it says 'u can use NLSSORT with create index statement' and i use it.

CREATE INDEX nls_index ON my_table (NLSSORT(name, 'NLS_SORT = XTURKISH')); but it doesnt work.

can anybody help me.i wanna use it with create index statement so i dont have to use NLSSORT statement with ORDER BY everytime.

Thanks for attention Received on Thu Apr 27 2006 - 02:17:12 CDT