Datatables sorting help

Datatables sorting help

maxmcclomaxmcclo Posts: 1Questions: 0Answers: 0
edited March 2013 in General
I am a Datatables newbie and have a question regarding the column sorting.
I have had read through the doco but still can't figure out what to do.
I am using Datatables in its most simplest form but can't seem to understand what is happening when I sort one of my columns.

I have a column which contains strings which are a combination of a city name and a year e.g. 'Darwin 1997', when I sort the column it is sorting the years first and then the city names within that year. Why would it do this? Surely the default sort should be by the city name.
How can I override this functionality so that it sorts the string alphabetically.
Thanks.
This discussion has been closed.