Issue with SQL ntext

Danny.DJ.DeBeer

Hi,
I am using the northwind SQL server database as a test datas ource to prototype various Datatable options. I came across a scenario where I am unable to read fields of type ntext.

I get the following exception message:
DataTables warning: table id=CustomerDemographics - The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator.

Is there any workaround or solution for this?

I'm using the .Net version of Datatables and a MVC Controller

Thanks

bindrid

Simplest solution is to just turn off sorting for that column  { "orderable": false },