null value in my sAjaxSource

CharlyPoppins

Hi,

I've got some null value in my sAjaxSource result. null occurred when there are accents in the record.

What can I do to prevent that ?

allan

You could use sDefaultContent as an empty string - i.e. "sDefaultContent": "".

You need to tell DataTables how to render 'null' data basically since it can't really display null itself.

Allan

CharlyPoppins

Thanks, but that's not the real problem. I don't understand why I've got null values in my sAjaxSource results ( like ["1201",null,"84510","CAUMONT SUR DURANCE","0490451234"] ). I should have "GENO Danièle" instead of null.
That happens with every records with accents.

allan

Oh I see - what is generating your JSON feed? The problem will be there. Sounds like you might need to set the character set that you are reading from the database.

Allan

CharlyPoppins

Of course... Thanks a lot :)