plugins - PHP if statement with German umlauts

Closed. This question is off-topic. It is not currently accepting answers.

---

Your question should be specific to WordPress. Generic PHP/JS/SQL/HTML/CSS questions might be better asked at Stack Overflow or another appropriate Stack Exchange network site. Third-party plugins and themes are off-topic for this site; they are better asked about at their developers' support routes.

Closed 6 years ago.

Improve this question

Im sure someone can help here pls. I have an problem with German Umlauts (ä,ü,ö)

Code

$wppost_interpret = $this->data['track']['itunes']['artistName'];
$wppost_interpret_title = $this->data['track']['itunes']['trackName'];

$wppost_exist_1 = exec("wp db query 'SELECT post_title FROM wp_posts WHERE post_title LIKE \"$wppost_interpret_title - $wppost_interpret\" LIMIT 1' --path='/var/www/ccc/htdocs' --quiet");

if ($wppost_exist_1 == "$wppost_interpret_title - $wppost_interpret") {
// nothing
echo "true";
} else {
echo "false";
// do something
};

The full script is working like I want. But when it coming to Titles like "Die Hände zum Himmel", my output is always "false".

Closed. This question is off-topic. It is not currently accepting answers.

---

Your question should be specific to WordPress. Generic PHP/JS/SQL/HTML/CSS questions might be better asked at Stack Overflow or another appropriate Stack Exchange network site. Third-party plugins and themes are off-topic for this site; they are better asked about at their developers' support routes.

Closed 6 years ago.

Improve this question

Im sure someone can help here pls. I have an problem with German Umlauts (ä,ü,ö)

Code

$wppost_interpret = $this->data['track']['itunes']['artistName'];
$wppost_interpret_title = $this->data['track']['itunes']['trackName'];

$wppost_exist_1 = exec("wp db query 'SELECT post_title FROM wp_posts WHERE post_title LIKE \"$wppost_interpret_title - $wppost_interpret\" LIMIT 1' --path='/var/www/ccc/htdocs' --quiet");

if ($wppost_exist_1 == "$wppost_interpret_title - $wppost_interpret") {
// nothing
echo "true";
} else {
echo "false";
// do something
};

The full script is working like I want. But when it coming to Titles like "Die Hände zum Himmel", my output is always "false".

• plugins
• php
• wp-cli

Share Improve this question edited Feb 10, 2019 at 12:51 scysys asked Feb 10, 2019 at 12:42 scysysscysys 111 bronze badge

Add a comment  | 

1 Answer 1

Sorted by: Reset to default 1

This is probably because of your database collation. There are numerous questions on StackOverflow about this sort of thing. Your question may get closed or migrated as it's not on-topic for wordpress.stackexchange;

Take a look at this question, or perhaps ask there instead.

Also, why are you not using the WordPress WP_Query class to return posts?