sirphuzz

I’m experiencing the exact same problem. I run a site the makes use of custom post types as well as custom taxonomy.

$premises = mysql_query("SELECT wterms.name, wterms.term_id
FROM wp_terms wterms
JOIN wp_term_taxonomy tax ON wterms.term_id = tax.term_id
JOIN wp_icl_translations t ON tax.term_taxonomy_id = t.element_id
WHERE tax.taxonomy = 'city' AND t.language_code = 'sv' AND t.element_type ='tax_city' AND tax.count <> 0
ORDER BY name ASC");

?>
<ul class="city-list">
<?php

$args = array(
'post_type' => 'premise',
'posts_per_page' => -1
);
$cityposts2 = get_posts($args);
if (count($cityposts2)>0) {
while ($query = mysql_fetch_assoc($premises)) {

$args = array(
'post_type' => 'premise',
'posts_per_page' => -1,
'city' => $query[name]
);
$cityposts = get_posts($args);
if (count($cityposts)>0) {
echo '<li>'.the_ttftext($query[name],true,'citylist');
foreach($cityposts as $post) :
   	setup_postdata($post);

This code basically checks to see if the taxonomies (cities) have any posts, and if they do, it displays the city name and all of its posts undername.

On 2.8 this worked perfectly.

However, after upgrading to 3.1 (I skipped a few), whenever I have a taxonomy (city name) with special characters, such as ?, ? and ? (Swedish names use these) the query seems to return this as no posts. Neither the city name or the posts are displayed.

However, I can open the post directly, and it displays fine, and on that single post site, I do display the taxonomy and on that page the special character is shown correctly(!).

It leads me to think there is something with the SQL query and the WP files that have a mismatch somehow.

Did something change with the charset settings that could have this effect? I use utf8, and always have been.

At least it’s nice to find that I’m not alone with this issue… ??