Mysql select data not working because string is utf-8

Question

I'm having a problem while executing a SELECT query. Namely, I use an external API to analyze whether articles are in my database. I noticed that the source encoding is UTF-8 while my base encoding is utf8mb4_general_ci. When attempting a SELECT query, the articles are not found in the database, but if I set the same content in the variable in the PHP editor, they are searched correctly. Do you have any idea how to fix this? Regards

<?php 
//from url json result
$title = 'G‐Eazy';
echo mb_detect_encoding($title)."\n\n"; //return: UTF-8 
//Not working
$query = "SELECT * FROM news WHERE title = '".$title."';";


$convert_title = mb_detect_encoding($title, 'UTF-8', 'ASCII');
echo $convert_title."\n"; //return: G?Eazy (- replace to ?)
echo mb_detect_encoding($convert_title)."\n\n"; //return: ASCII

//value set in editor php
$title = 'G-Eazy';
echo mb_detect_encoding($title)."\n\n"; //return: ASCII

//working
$query = "SELECT * FROM news WHERE title = '".$title."';";

?>

I tried to convert text using mb_convert_encoding function unfortunately I get errors. Below is my code with the result I get:

<?php

$title = 'G‐Eazy';
echo mb_detect_encoding($title)."\n\n"; //return: UTF-8
$convert_title = mb_convert_encoding($title, 'ASCII');
echo $convert_title."\n"; //return: G?Eazy (- replace to ?)
echo mb_detect_encoding($convert_title)."\n\n"; //return: ASCII



?>

Your problem, likely is simply that dash symbol is different in database and url. — Your Common Sense, Aug 12 '23 at 09:33
Do echo urlencode($string) where one $string is G‐Eazy taken from url and one written in your code and compare output. The part with % will show the difference. Hard to tell what to do though. I think you should replace one dash for another before comparison. — Your Common Sense, Aug 12 '23 at 09:47
Hi, I made a urlencode for the data from the url: " G%E2%80%90Eazy" — urbciech, Aug 12 '23 at 10:07
That's exactly what I said. There is a hundred ways to write a dash. — Your Common Sense, Aug 12 '23 at 10:23

Mysql select data not working because string is utf-8

0 Answers0