Sorting jquery data columns in Turkish

Question

I have a problem with sorting columns in jQuery Datatable. According to the Turkish alphabet, the data sorting order is incorrect. How can I achieve to get the correct Turhish sort result?

Answer 1

you can solve this problem by replacing the _fnEscapeRegex function like this // _fnEscapeRegex fonksiyonunu aşağıdaki gibi değiştirerek bu sorunu çözebilirsiniz ...

function _fnEscapeRegex ( sVal ) {

var letters = { "İ": "[İi]", "I": "[Iı]", "Ş": "[Şş]", "Ğ": "[Ğğ]", "Ü": "[Üü]", "Ö": "[Öö]", "Ç": "[Çç]", "i": "[İi]", "ı": "[Iı]", "ş": "[Şş]", "ğ": "[Ğğ]", "ü": "[Üü]", "ö": "[Öö]", "ç": "[Çç]" };
        var acEscape = [ '/', '.', '*', '+', '?', '|', '(', ')', '[', ']', '{', '}', '\\', '$', '^', '-' ];
        var reReplace = new RegExp( '(\\' + acEscape.join('|\\') + ')', 'g' );
        sVal=sVal.replace(reReplace, '\\$1');

        return sVal.replace(/(([İIŞĞÜÇÖiışğüçö]))/g, function (letter) { return letters[letter]; });
    }