... but you can call it whatever you like):
string DataCleansing.fn_DecodeHtmlEntities( string p_StringToDecode )
{
// initialize
v_StringToDecode = ifnull(p_StringToDecode,"");
//
// map string ...
... The solution above was as easy as that. Here are a number of other things I tried first:
mysql_set_charset(): No
iconv(): No
htmlentities(): No
preg_replace_callback(): No
sxe(): No
$xml ...
What?
A quick article showing my MySQL statement when I want to remove all the accents from foreign characters and return the English equivalent.
Why?
A content management system (CMS) that I'm ...
... SET latin1 COLLATE utf8-general-ci;
// set text fields to utf8
SET NAMES 'utf8';
This does nothing:
// convert the foreign character using PHP to htmlentities
$my_description = htmlentities($my_description);
$my_description ...
We use cookies to improve your experience on our website. By browsing this website, you agree to our use of cookies. Read more about our Privacy Policy.