Grid remains empty when loading special (diacritic) characters

[ArneaultParticipant]

Hi

I am experiencing the following problem: my grid displays data fine when loading mysql table with no special characters. But when loading a table with special (diacritic; ü ë ä á) characters, my grid remains empty. No error warning, but also no data.

Can you help me solving this problem?

Here is part of my code:
var dbsource =
{
datatype: “json”,
cache: false,
dataFields: databasefields,
url: url2
};

//database grid
$(“#databasetabel”).jqxGrid(
{
source: dbsource,
theme: theme,
width: ‘100%’,
height: ‘100%’,
pageable: true,
columnsResize: true,
sortable: true,
autoheight: true,
pageSize: 20,
pagermode: ‘simple’,
pagerButtonsCount: 10,
showstatusbar: true,
statusbarheight: 50,
editable: false,
editmode: ‘selectedrow’,
filterable: true,
columns: columns,
columngroups: [
{ text: ‘Records in database‘,
align: ‘center’,
name: columngroup
}
]
});
};

[ivailoParticipant]

Hi Arneault,

This problem is generated probably from your server side script, so it’s not related to the functionality of the grid.
If you are using php with json_encode() that may causes the problem with diacritic.
The result is returned null from the server. So you have to encode to UTF-8 these problematic characters in your server script.

Best Regards,
Ivailo Ivanov

jQWidgets Team
http://www.jqwidgets.com

[Author]

Posts