You are here:  » Special Character Problem in Product Mapping


Special Character Problem in Product Mapping

Submitted by technoarenasol on Mon, 2013-07-08 06:54 in

Hi David

Some special character title not accept in product mapping

Example :

Nokia Asha 302
=Nokia Âsha 302 Mobile
=ÂNokia Asha 302 Mobile
=Nokia Asha 302 Mobile & Phone

Thanks
Amin

Submitted by support on Mon, 2013-07-08 09:49

Hi Amin,

It sounds like it might be a database collation scenario. I've found that the new MySQLi version of the database library resolves a number of special character scenarios, so assuming that your site is configured as utf-8 (config.php line 4) if you could perhaps apply the PHP forward compatibility patch for your version (I think you're running 12/10B, it's in the revision.txt file) which you'll find the correct link to on this page that should resolve the problem.

If not, in the new includes/database.php look for the following code at line 16:

$database_link = @mysqli_connect($config_databaseServer,$config_databaseUsername,$config_databasePassword,$config_databaseName);

...and REPLACE with:

$database_link = @mysqli_connect($config_databaseServer,$config_databaseUsername,$config_databasePassword,$config_databaseName);
mysqli_set_charset($database_link,"utf8");

Hope this helps! If still not displaying correctly let me know and I'll check it out further for you...

Cheers,
David.
--
PriceTapestry.com