UTF-8 Encoding Problem with Spreadsheet

Hello,

It’s the first time I’m using dhtmlx so I’m sorry if it’s an easy question, but couldn’t find a solution that works for me.

Problem:
UTF-8 charset encoding doesn’t work for Turkish characters.
For example the letter ‘ş’ seems as ‘ÅŸ’ both in MySQL and with echo to the php page.
But in the spreadsheet table it seems correct as ‘ş’.

Solutions I tried:
php page is set for UTF-8 without BOM
All other php files in the php folder set for UTF-8 without BOM
MySQL is set for utf8_general_ci

Thanks!

I have added the following code to the db_common.php at line 934.
It seems to work now, I hope it can be helpful for others.

Code:
mysql_query(“SET NAMES ‘utf8’”);
mysql_query(“SET CHARACTER SET utf8”);
mysql_query(“SET COLLATION_CONNECTOIN = ‘utf8_turkish_ci’”);