Christian asked 7 years ago
Hi,
I'm using the Grid view to show Results of a form. The form generates the SQL Source for the gridView … everything works fine.
Only if I search for something with an German umlaut, the grid view "shows no data found" (in SQL Server is a result). For Example SELECT Name, vorname WHERE Name Like '%Müller%'
MySQL collation ist utf8_general_ci
thanks for your help
Abu Ghufran answered 7 years ago
Hello,
Can you check what query is actually sent to php grid?
e.g.
$g->select_command = "SELECT clients.client_id, name, gender, ……………….";
After this, you can put echo $g->select_command; die; to see what is actually passed in query.
If your database is mysqli, there is no known issues for utf8. If using sql server, latest driver is required.
Abu Ghufran answered 7 years ago
If using mysql, you can also enable mysql query log and see the query executed by grid.
