Anand asked 1 month ago
I have a grid that reads data from MSSQL table which has names in Greek characters. The grid displays an error with blank message but when I remove the column with greek characters it works. How do I make the grid to work with Greek characters?
1 Answers
Abu answered 4 weeks ago
Issues solved via live chat.
Just to log the solution, Mssql native php driver does not handle some unicode characters properly, while when we use PDO driver, it works fine. So we changed connection to use PDO instead of Mssql native driver.
example:
$db_conf = array();
$db_conf["type"] = "pdo";
$db_conf["server"] = "sqlsrv:Server=(local)\sqlexpress";
$db_conf["user"] = ""; // username
$db_conf["password"] = ""; // password
$db_conf["database"] = "master"; // database
$g = new jqgrid($db_conf);
Your Answer
