DMXzone App Connect Support Product Page
How do I stop special characters showing as things like â€™ ?
14 Jun 2018 13:25:00
14 Jun 2018 13:25:00 Bruce Wilkie posted:
I'm replacing all my old php pages with html pages, using Server Connect and App Connect
But in the new pages I'm seeing jumbled characters like â€™ where there used to be normal special characters such as apostrophes etc.
The database is the same and both the php and html pages have the tag <meta charset="utf-8"> in the header.
Is there something else I need to set to fix it so that the html pages show normal special characters?
thanks in advance
14 Jun 2018 13:40:57
14 Jun 2018 13:40:57 Teodor Kuduschiev replied:
you need to make sure your database collation is set to UTF8 (utf8-general-ci). Also the PHP scripts you used before may have stored the data in the database incorrectly (not as UTF8) which is now an issue with a real UTF8 database and page.
14 Jun 2018 13:52:59
14 Jun 2018 13:52:59 Bruce Wilkie replied:
I''ve converted the database to uft8-general-ci now within phpmyadmin.
Characters showing up wrong still, so I'll go through and update the individual characters next, and then update the scripts that insert and edit the data.
Thanks for the quick reply
14 Jun 2018 14:05:34
14 Jun 2018 14:05:34 Teodor Kuduschiev replied:
Converting the database to utf-8 won't fix the issue they have not been added as utf-8 by the PHP script. These have to be manually changed.
07 Aug 2018 13:41:54
07 Aug 2018 13:41:54 Bruce Wilkie replied:
08 Aug 2018 06:56:04
08 Aug 2018 06:56:04 Teodor Kuduschiev replied:
The problem with your page is that the data was not stored into the database as UTF8. What i mean is the script you used to store it, didn't properly send it to the database fields as such which is the case if you are using the DW server behaviors to do so. Probably set names utf8 was missing:
Server connect expects a properly inserted UTF8 data in your database so that it handles it as such, and the result is broken unicode characters.
08 Aug 2018 15:37:12
08 Aug 2018 15:37:12 Bruce Wilkie replied:
Thanks for the tip there Teodor.
I've googled "set names utf8 dreamweaver server behaviors" and found your response to a similar enquiry on the Wappler support site at
Following the instructions there I've now added the line:
mysql_query('set names utf8', $connection_name);
to the end of the Dreamweaver connection script
All now working great
08 Aug 2018 17:48:54
08 Aug 2018 17:48:54 Teodor Kuduschiev replied:
Great that you have this fixed
Nice SEO on the wappler community also - this reply is a few hours old
Reply to this topic Login to Reply