Found a bug in MySQL Connector when having strange char

Suite and Optimus Suite 5
#1

Hi.

I’m building a very simple page, and i’m experienssing a serious issue loading data from MySQL.

Here is my data :

insert into base.table values
(1,'test'),
(2,'test with ²');

And when i try to load XML from this table CONTAINING the char ² i have a bad XML output.

Here is my PHP code :

[code]<?php

require_once(“Common/dhtmlxConnector_v10_php/codebase/grid_connector.php”);

$res=mysql_connect(DEFAULT_MYSQL_SERVER.“:”.DEFAULT_MYSQL_PORT,DEFAULT_MYSQL_USER,DEFAULT_MYSQL_PASSWORD);
mysql_select_db(“base”);

$gridConn = new GridConnector($res,“MySQL”);
$gridConn->render_table(“table”,“id”,“label”);
?>
[/code]

#2

Ok it works when i do that :

mysql_query("set names 'utf8'");