sql SELECT with german Umlauts

Questionssql SELECT with german Umlauts
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

2 Answers
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.

Your Answer

15 + 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?