Grid PHP Connector XML Error Special Chars (degree sign)

Suite and Optimus Suite 5
#1

When I use the following code to generate my grid, I get an XML error when data has special characters like the degree character °C.

$grid = new GridConnector($res,“Oracle”);
$grid->render_complex_sql(‘tableName’ ,‘id’, ‘col1,col2,col3’);

This is the error

Message from webpage
Error type:LoadXML
Description:Incorrect XML

Please advice.

#2

Try to use

$grid = new GridConnector($res,"Oracle"); $grid->set_encoding("iso-8859-1");

#3

That worked!!! Thank you.