Support » Plugins and Hacks » Hacks » $wpdb and accented chars

  • Hello,

    I write my first wordpress plugin and I’ve problems with the wpdb class.

    I have a string in my table who is ‘Gfa’, note there is no accent.
    If I search the string ‘Gfà’, It shows me the non accented char…

    If i do this SELECT myself through a standalone script, the problem doesn’t appears.

    what is not working as expected:

    $wpdb->get_results("SELECT * FROM {$table_roster} WHERE nom = 'gfâ'");
    $wpdb->query("SELECT * FROM {$table_roster} WHERE nom = 'gfâ'");

    using $wpdb->prepare has no difference

    what is working as expected:

    mysql_query("SELECT * FROM {$table_roster} WHERE nom = 'gfâ'");

    please help me, I’m blocked on It since yesterday ;'(

  • The topic ‘$wpdb and accented chars’ is closed to new replies.