Loading data with special charset using GridConnector

Suite and Optimus Suite 5
#1

Hello,

I’m using a grid with an connector (GridConnector) which loads data from a mysql. It worked fine until I insert data with french charset like ‘élèves’. I search related topic in vain. How can I do to solve this problem?

Regards

#2

If you are using UTF-8 for both client side and DB it must work from the box.
If you are using non-utf db, you need to set locale before render_table|render_sql command

$conn->set_encoding(“iso-8859-1”);

#3

I use $conn->set_encoding(“iso-8859-1”) and it’s worked fine.
Thanks