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 questionIm 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 questionIm 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".
Share Improve this question edited Feb 10, 2019 at 12:51 scysys asked Feb 10, 2019 at 12:42 scysysscysys 11 bronze badge1 Answer
Reset to default 1This 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?