ASCII characters in mysql tables, not view correctly in the browser.

I'm upgrading an old website with the new DataBridge v2.
Now I've a problem with ASCII characters in the records of the database's table.
For example, the code « view in the browser with « instead of "«".
In the db connection file I've insert this code but without success:
$connTest->set_charset('utf8');

Is there any solution?

I just updated the extension to fix this issue in the latest rsobj.php file. If you reinstall the extension and re-apply the recordset object, it should replace the file. I've also attached it, so you can replace it manually.

Hi Ray,
it's perfect. Thanks.

A last question, now if I regenerate the connection file, I've these two new instructions:
$connTest = mysqli_init();
$connTest->options(MYSQLI_OPT_INT_AND_FLOAT_NATIVE, TRUE);

Do you confirm me that is necessary to regenerate the connection file?
Thanks.

It is not necessary. The connection was updated to use that syntax to preserve the native data types for returned data. So that integers stay integers instead of returning as strings. In 99% of cases wouldn't matter, but a user found it wasn't integrating with a charting plugin properly because of the data type so I made the change.

Ok, thanks Ray!

Hi Ray,
I've a new problem with the characters in the records of the database's table (see screenshots in the private area).
I've a field in a mysql's table (type "text") with html content (e.g. "p" tags) but when I open the page in the browser I see the html structure with the tags.

For example, if I have in the field:
<p>Lorem ipsum...</p>

The browser view...
<p>Lorem ipsum...</p>

and not:
Lorem ipsum...

How can I fix it?
Thanks.

Yes. We have built in Cross Site Scripting (XSS) security in the new MySQLi code. It will automatically encode html entered to prevent malicious attempts by hackers to inject code or script onto your page. In order to disable the protection you can manually update your column reference from:

<?php echo $rsNewsProducts->getColumnVal('desc_ita_news'); ?>

to:

<?php echo $rsNewsProducts->getColumnVal('desc_ita_news',false); ?>

Perfect, thanks!