Problems with SQL string with a vowel mutation

Question

I do execute a SQL string via PHP.

SELECT *
FROM dDokumente
WHERE dMandant = '26'
AND dName LIKE '%wäsche%'
AND dActive = '1'
ORDER BY dDokID

if I execute it via PHP MyAdmin I get 2 results (which is correct) but as soon as I execute it via my PHP page it shows 0 results.

MySql Database is UTF8_general_ci.

The SQL string seems to be correct if I display it on the page.

Does anyone have an idea what I could do?

Have you configured your MySQL connection to use a UTF8 based collation? — Nico Haase, Jun 25 '18 at 08:44
Possible duplicate of [UTF-8 all the way through](https://stackoverflow.com/questions/279170/utf-8-all-the-way-through) (I'm guessing you forgot to set the charset on the connector) — CD001, Jun 25 '18 at 08:53
It was the charset on the connector,... that you all for your help! would you post your comment as an answer so I can mark it as correct? — tpensel, Jun 25 '18 at 09:42

score 0 · Answer 1 · answered Jun 25 '18 at 08:41

0

Make sure everything is UTF-8.

Open your PHP script in your IDE, and check the file encoding is also set to UTF-8.

In windows, you'll probably be on windows-1252 or iso-8559-1 (AVOID!)

Also, if it's on a web page, make sure your HTML also declares the file encoding as utf-8 in the meta tags

answered Jun 25 '18 at 08:41

delboy1978uk

I just revised everything,... Document is utf-8 Meta Tags are uff-8. But still nothing,... – tpensel Jun 25 '18 at 09:26

1 Answers1