Hi,
we have a problem to save special characters (german umlauts) in our database by the Grid.
Grid: äüö@€
DB: äüö@€
Could you help me please ?
Thanks
Best regards.
Markus
Hello,
Please confirm if you are using mssqlnative php extension to connect sql server.
This extension supports utf8 and work smooth.
e.g.
$db_conf = array();
$db_conf["type"] = "mssqlnative";
$db_conf["server"] = "(local)sqlexpress"; // ip:port
$db_conf["user"] = null;
$db_conf["password"] = null;
$db_conf["database"] = "master";
hi, what if im not using nativemssql ? I use mssql and i cannot render data with non english characters. For example \”Ñ\”…. the render is not working in this cases.
Logging answer for others:
Try following:
Edit lib/inc/jqgrid_dist.php and Search+replace:
$responce->rows[] = $row;
With:
$responce->rows[] = array_utf8_encode_recursive($row);
It should do manual encode of each data array item, before sending to JS.