I have a GRID populated with data from a mysql utf8 encoded database and table. Unless I convert special characters to HTML, the xml generated become corrupt (black ? symbols appear in the place of special characters within the CDATA field in the alert with the xml content) and the grid does not shows the data. I have searched the forum and found many different things to try but so far could not find a solution.
My mysql connection is given by this file:<?php require_once("../dhtmlxconnector/dhtmlxConnector_php/codebase/grid_connector.php"); include("../../../includes/botanicaamazon3_clean.php"); $grid = new GridConnector($res); $grid ->dynamic_loading(100); $grid ->render_table("batchenter_especimenes_386_89"); ?>
Tried adding line echo “<?xml version='1.0' encoding='UTF-8' ?>”; to this file and also putting the grid_connector.php in the first line of this file, as suggested somewhere.
I’ve also experimented adding the line dp.enableUTFencoding(false) in my grid file that loads the xml generated by the file above:
dp = new dataProcessor(“myfile”);
My grid file has the meta charset as UTF-8…
So, everything is in UTF-8, which I use as standard!