May 21 2019

Turkish Characters Order By Sort Problem in Oracle

Category: Errors and Solutions,SQLFatih Acar @ 09:43

Using order by in column that contains special Turkish characters like ç,ğ,ö,ş,ü can be problem. All special Turkish characters can be listed at the end of the list. You can resolve this problem with NLSSORT.

select * from tablename order by NLSSORT(columnname,’NLS_SORT=TURKISH’)

3,180 total views, 15 views today

facebook comments:

Leave a Reply

Time limit is exhausted. Please reload CAPTCHA.