{"id":2596,"date":"2019-05-21T09:43:32","date_gmt":"2019-05-21T06:43:32","guid":{"rendered":"https:\/\/www.fatihacar.com\/blog\/?p=2596"},"modified":"2019-05-21T09:49:46","modified_gmt":"2019-05-21T06:49:46","slug":"turkish-characters-order-by-sort-problem-in-oracle","status":"publish","type":"post","link":"http:\/\/www.fatihacar.com\/blog\/turkish-characters-order-by-sort-problem-in-oracle\/","title":{"rendered":"Turkish Characters Order By Sort Problem in Oracle"},"content":{"rendered":"\n<p>Using order by in column that contains special Turkish characters like \u00e7,\u011f,\u00f6,\u015f,\u00fc can be problem. All special Turkish characters can be listed at the end of the list. You can resolve this problem with NLSSORT.<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p>select * from tablename order by NLSSORT(columnname,&#8217;NLS_SORT=TURKISH&#8217;)<\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"<p>Using order by in column that contains special Turkish characters like \u00e7,\u011f,\u00f6,\u015f,\u00fc 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,&#8217;NLS_SORT=TURKISH&#8217;)<\/p>\n","protected":false},"author":37,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[53,6],"tags":[],"class_list":["post-2596","post","type-post","status-publish","format-standard","hentry","category-oracle-errors-and-solutions","category-oracle-sql"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p39NFI-FS","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2596","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/users\/37"}],"replies":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/comments?post=2596"}],"version-history":[{"count":4,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2596\/revisions"}],"predecessor-version":[{"id":2600,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2596\/revisions\/2600"}],"wp:attachment":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/media?parent=2596"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/categories?post=2596"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/tags?post=2596"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}