Encoding special chars

Suite and Optimus Suite 5
#1

HI,

First, sorry for my poor english.
I have a problem of encoding special chars, when using dhtmlx grid and connector.
All my files (html & php) are encoding and declared in utf-8, so mysql (server,db,table,data) too.
But when i use pecial chars in web browser to fill the cell, th display is ok but not in the mysql db where appear like é …

#2

Double-check the DB settings. It possible to define collation for database or separate labels. If any of it set as non-UTF, mysql will convert unicode to ASCII, which will provide result similar to above one

#3

I verified twice with phpmyadmin, my server sql is utf8_general_ci, the datatbase is utf8_general_ci, the table is utf8_general_ci and the columns is utf8_general_ci … :cry:

#4

Which kind of connectors you are using using ? ( php, java, .net )

#5

I’m using php (with the grid_connector.php).
I’m trying encoding in ISO8859-1 (files, serveur, database,table) and same problem.

#6

Please try to use the attached dhtmlxcommon.js instead of the original one, it will force utf-8 encoding during data saving requests. Normally it is not necessary for php servers, still may help in your case.
dhtmlxcommon_36_utf.zip (6.97 KB)