*State / Province: special characters

Author	« Topic »
nickm Advanced Member Germany 443 Posts Pre-sales questions only (More Details...)	Posted - 12/19/2018 : 20:28:29 We have recently updated our site to ECT 7.0.2 to enable us to use PHP 7.1. So far so good. In addition, we also took this opportunity to switch the site from ISO-8859-1 to UTF-8 as we had always had intermittant issues with special language characters. We now have an issue where a diamond with question mark is appearing in a few addresses iand orders in the database. Irritating but not a real show-stopper. Today we now have an issue with *State / Province: which is really strange. An example: when selecting Bouche du Rhône from the drop-down list associated with France where Bouche du Rhône appears as it should we get [Bouche du R h & o c i r c ; n e] entered in the field. Clearly something is amiss with the UTF-8 in the Admin or database. Edited by - nickm on 12/20/2018 02:04:18
dbdave ECT Moderator USA 10468 Posts	Posted - 12/19/2018 : 21:15:22 The first thing I would check is to be sure your admin pages and store pages are on the same character set. You can view source to see that. If the admin is not on utf-8 but your front end is, then set the following in your includes - $adminencoding=utf-8;
nickm Advanced Member Germany 443 Posts Pre-sales questions only (More Details...)	Posted - 12/19/2018 : 21:35:21 $adminencoding="UTF-8"; already in includes.php. Just spotted <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> in /admin/login.php Could this be the problem? Just changed it and - no it wasn't the answer. Edited by - nickm on 12/19/2018 21:48:39
Andy ECT Moderator 95440 Posts	Posted - 12/20/2018 : 00:26:26 Hi Nick Can you go to the database utility in the admin and under Database Collation see what you have the tables set to there? Andy Please feel free to review / rate our software
nickm Advanced Member Germany 443 Posts Pre-sales questions only (More Details...)	Posted - 12/20/2018 : 00:31:54 utf8_general_ci
Andy ECT Moderator 95440 Posts	Posted - 12/20/2018 : 01:43:03 That should be fine. Now you are using utf-8, can you go into the admin States page for France and reenter Bouche du Rhône and that should save it under utf-8. Andy Please feel free to review / rate our software
nickm Advanced Member Germany 443 Posts Pre-sales questions only (More Details...)	Posted - 12/20/2018 : 02:01:51 I understand it should but it doesn't. When selecting Bouche du Rhône from the drop-down list associated with France, where Bouche du Rhône appears as it should in the drop-down list, we get [Bouche du R h & o c i r c ; n e] entered in the field. Edited by - nickm on 12/20/2018 02:03:46
Andy ECT Moderator 95440 Posts	Posted - 12/20/2018 : 08:40:37 This is now fixed I believe as the addresses were saved from before in the customer accounts - is that right? Andy Please feel free to review / rate our software
nickm Advanced Member Germany 443 Posts Pre-sales questions only (More Details...)	Posted - 12/20/2018 : 19:16:14 Yes. That's correct.
	« Topic »