$wpdb and accented chars (1 post)

  1. gfmobi
    Posted 5 years ago #


    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 ;'(

Topic Closed

This topic has been closed to new replies.

About this Topic


No tags yet.