I have a problem with Greek characters in a query.

Here is the code

Using the Greek characters in the 'meta_value' => 'Ναι' the query can't work, because of the language.

How can i make it work?

  • 1
    Why shouldn’t that work? What is the value of the constant DB_COLLATE?
    – fuxia
    Jun 4 '13 at 16:09
  • @toscho, it was empty: define('DB_COLLATE', '');
    – Charitos
    Jun 4 '13 at 17:11
  • Use utf8_unicode_ci and try again.
    – fuxia
    Jun 4 '13 at 17:20
  • @toscho, nothing changed. It gives me a blank category, when i just change the "Ναι" to "Yes" it gives me the posts in the category..
    – Charitos
    Jun 4 '13 at 17:31
  • Enable the debug mode and inspect the actual database query.
    – fuxia
    Jun 4 '13 at 17:33

This is the loop I've created to display post's matching criteria on empty page:

// get results
$the_query = new WP_Query( 'meta_key=apaitei_logariasmo_facebook&meta_value=Ναι' );

// The Loop
if( $the_query->have_posts() )
    while ( $the_query->have_posts() ) {
        echo '<h3>'; the_title(); echo '</h3>';

It works. Look at the image:

Page with post listed

Note: my site's language is English with:

define('DB_CHARSET', 'utf8');
define('DB_COLLATE', '');

How do you know that your query returns no posts if you don't display anything. At least the code you provided does not show it.

  • i editted the main question and hyperlinked the code i use for the category template.
    – Charitos
    Jun 8 '13 at 12:58

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.