MSSQL database based on Greek_CI_AS not working

QuestionsMSSQL database based on Greek_CI_AS not working
Anand asked 2 weeks 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 6 days 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

19 + 1 =

Login with your Social Id:

OR, enter

Attach code here and paste link in question.
Attach screenshot here and paste link in question.



How useful was this discussion?

Click on a star to rate it!

Average rating 0 / 5. Vote count: 0

No votes so far! Be the first to rate it.

We are sorry that this post was not useful for you!

Let us improve this post!

Tell us how we can improve this post?