Case insensitive sort

plw

Is there a way of of doing a case insensitive sort please. There must be lots of people who need it so I can't believe it isn't possible

colin

The default behaviour is case insensitive searches - for example, type "ashton" on the home page table. If you want to disable it, you can use search.caseInsensitive,

Colin

plw

I know and I wish it wasn't . I just have and it still hasn't made any difference (:

$(document).ready(function () { 
               var groupColumn = 4;
               $("#DTable").dataTable({ 
                   "search": {
                    "caseInsensitive": true
                      },
                   "pageLength": 30,
                   autoWidth: false,
                   columnDefs: [
                        { type: 'natural-nohtml', targets: '0' },
                       { type: 'natural-ci', targets: '1' },
                        { visible: false, targets: groupColumn }
                    ],
                  
                   "lengthMenu": [ 10, 25, 30, 50, 75, 100 ],
                   "bFilter": false,
                   "aaSorting": [[ 0, 'asc' ]],
                   "aoColumns": [ 
                       { "bSortable": true },                       
                       { "bSortable": true },                     
                       { "bSortable": true },
                       { "bSortable": true },
                       { "bSortable": false }
                   ],
                   drawCallback: function (settings) {
                    var api = this.api();
                    var rows = api.rows({ page: 'current' }).nodes();
                    var last = null;
                    var TheRowCount = 1;
                    api
                        .column(groupColumn, { page: 'current' })
                        .data()
                        .each(function (group, i) {
                            if (last !== group) {
                                if (TheRowCount == 1) {
                                    $(rows)
                                        .eq(i)
                                        .before('<tr class="group"><td colspan="4" bgcolor="#ffffcc">' + group + '</td></tr>');
                                }
                                else {
                                    $(rows)
                                        .eq(i)
                                        .before('<tr class="group"><td colspan="4" bgcolor="#ffffcc"><hr style="padding: 0px; margin: 0px; background-color: black; border: 0px; height: 2px;">' + group + '</td></tr>');
                                }
                                last = group;
                            }
                            TheRowCount++;
                        });
                },
               });
           });      

I am stuck

Edited by Colin - Syntax highlighting. Details on how to highlight code using markdown can be found in this guide.

tangerine

The default behaviour is case insensitive searches

Do you actually want case sensitive?
"caseInsensitive": true doesn't change anything. It's the default.

plw

I am trying to sort not search and nothing I have tried makes any Difference.

colin

Ah sorry, I misread that to be "search", not "sort" - apologies. But that said, sorts also are case-insensitive - see here ("ashton cox"). You can use the case-sensitive sorting plugin if you don't want that behaviour.

Colin

plw

I have just realised that sorted out my Sort Problem as well anyway so thanks for you suggestion. I thought you must have misread it as search but it worked - hurray

allan

Correct - DataTables sorting is case-insensitive by default as shown in the source here.

There is an exception to that though - if you are using server-side processing, then it is up to the server what ordering is applied. Some databases will be case-sensitive by default.

Allan