why it is unable to sort by patient id?

mssjdb

am using datatables to list out patient details. here am unable to sort this by patientid. these values are getting from db. patientid is a varchar type on database.

am using "aaSorting": [[ 1,'desc']], to sort patientid as default. but these are not in sorted order. how to solve this ?

allan

Link to a test case please: http://datatables.net/forums/discussion/12899/post-test-cases-when-asking-for-help-please-read