WordPress query wpdb-> prepare problem with special sign?

  • gooctwb

    (@gooctwb)


    11 years, 2 months ago

    $link = $wpdb->esc_like( $link );
$link = $powiatowe.'%';
$sql= "SELECT DISTINCT SQL_CACHE woj, pow, nazwa FROM miejscowosci WHERE woj = '$woj' AND pow = '$pow' AND nazwa = '$nazwa'"; //OK
$sqlz = $wpdb->prepare( $sql, $link, $link );
$query_db = $wpdb->get_results( $sqlz );

    I have problem with mysql query, this query ignore polish sign :/ when I search “Łódź” I take, empty results

Viewing 1 replies (of 1 total)
Viewing 1 replies (of 1 total)

The topic ‘WordPress query wpdb-> prepare problem with special sign?’ is closed to new replies.

Tags