Menu
<li>Jain R.K. and Iyengar S.R.K., “Advanced Engineering Mathematicsâ€, Narosa Publications,</li>
i have lot a raw html string in database. all the text have these weird characters. how can i convert to normal text for saving back it back in database.
$final = '<li>Jain R.K. and Iyengar S.R.K., “Advanced Engineering Mathematicsâ€, Narosa Publications,</li>';
$final = utf8_encode($final);
$final = htmlspecialchars_decode($final);
$final = html_entity_decode($final, ENT_QUOTES, "UTF-8");
$final = utf8_decode($final);
echo $final;
i tried above code, it displays correctly in web browser but still saving the same weird characters in database.
the charset of database is utf-8
852
Going backwards from UTF-8 to ISO-8859-1 will cause "replacement characters" (�) to appear in your text when unsupported characters are found. byte[] utf8 = ... byte[] latin1 = new String(utf8, "UTF-8"). getBytes("ISO-8859-1"); You can exercise more control by using the lower-level Charset APIs.
This answer is not useful. Show activity on this post. “ is "Mojibake" for “ . You could try to avoid the non-ascii quotes, but that would only delay getting back into trouble.
In order to convert a String into UTF-8, we use the getBytes() method in Java. The getBytes() method encodes a String into a sequence of bytes and returns a byte array. where charsetName is the specific charset by which the String is encoded into an array of bytes.
Click Tools, then select Web options. Go to the Encoding tab. In the dropdown for Save this document as: choose Unicode (UTF-8). Click Ok.
“ is "Mojibake" for “. You could try to avoid the non-ascii quotes, but that would only delay getting back into trouble.
You need to use utf8mb4 in your tables and connections. See this for the likely causes of Mojibake.
151
$final = '<li>Jain R.K. and Iyengar S.R.K., “Advanced Engineering Mathematicsâ€, Narosa Publications,</li>';
$final = str_replace("Â", "", $final);
$final = str_replace("’", "'", $final);
$final = str_replace("“", '"', $final);
$final = str_replace('–', '-', $final);
$final = str_replace('â€', '"', $final);
for past datas, i replaced the weird characters with UTF-8 characters.
for future datas, i made the charset to utf8 in php, html and databases connections.
8
It safer to use ftfy tool to fix texts https://ftfy.readthedocs.io/en/latest/
3
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
