{"action":"created","issue":{"url":"https://api.github.com/repos/cubecart/v6/issues/195","labels_url":"https://api.github.com/repos/cubecart/v6/issues/195/labels{/name}","comments_url":"https://api.github.com/repos/cubecart/v6/issues/195/comments","events_url":"https://api.github.com/repos/cubecart/v6/issues/195/events","html_url":"https://github.com/cubecart/v6/issues/195","id":57183723,"number":195,"title":"Currency Symbols","user":{"login":"bhsmither","id":4073092,"avatar_url":"https://avatars.githubusercontent.com/u/4073092?v=3","gravatar_id":"","url":"https://api.github.com/users/bhsmither","html_url":"https://github.com/bhsmither","followers_url":"https://api.github.com/users/bhsmither/followers","following_url":"https://api.github.com/users/bhsmither/following{/other_user}","gists_url":"https://api.github.com/users/bhsmither/gists{/gist_id}","starred_url":"https://api.github.com/users/bhsmither/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bhsmither/subscriptions","organizations_url":"https://api.github.com/users/bhsmither/orgs","repos_url":"https://api.github.com/users/bhsmither/repos","events_url":"https://api.github.com/users/bhsmither/events{/privacy}","received_events_url":"https://api.github.com/users/bhsmither/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/cubecart/v6/labels/bug","name":"bug","color":"e11d21"}],"state":"closed","locked":false,"assignee":{"login":"abrookbanks","id":4520803,"avatar_url":"https://avatars.githubusercontent.com/u/4520803?v=3","gravatar_id":"","url":"https://api.github.com/users/abrookbanks","html_url":"https://github.com/abrookbanks","followers_url":"https://api.github.com/users/abrookbanks/followers","following_url":"https://api.github.com/users/abrookbanks/following{/other_user}","gists_url":"https://api.github.com/users/abrookbanks/gists{/gist_id}","starred_url":"https://api.github.com/users/abrookbanks/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/abrookbanks/subscriptions","organizations_url":"https://api.github.com/users/abrookbanks/orgs","repos_url":"https://api.github.com/users/abrookbanks/repos","events_url":"https://api.github.com/users/abrookbanks/events{/privacy}","received_events_url":"https://api.github.com/users/abrookbanks/received_events","type":"User","site_admin":false},"milestone":{"url":"https://api.github.com/repos/cubecart/v6/milestones/7","labels_url":"https://api.github.com/repos/cubecart/v6/milestones/7/labels","id":973725,"number":7,"title":"6.0.0","description":"","creator":{"login":"abrookbanks","id":4520803,"avatar_url":"https://avatars.githubusercontent.com/u/4520803?v=3","gravatar_id":"","url":"https://api.github.com/users/abrookbanks","html_url":"https://github.com/abrookbanks","followers_url":"https://api.github.com/users/abrookbanks/followers","following_url":"https://api.github.com/users/abrookbanks/following{/other_user}","gists_url":"https://api.github.com/users/abrookbanks/gists{/gist_id}","starred_url":"https://api.github.com/users/abrookbanks/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/abrookbanks/subscriptions","organizations_url":"https://api.github.com/users/abrookbanks/orgs","repos_url":"https://api.github.com/users/abrookbanks/repos","events_url":"https://api.github.com/users/abrookbanks/events{/privacy}","received_events_url":"https://api.github.com/users/abrookbanks/received_events","type":"User","site_admin":false},"open_issues":1,"closed_issues":1,"state":"open","created_at":"2015-02-10T14:49:58Z","updated_at":"2015-02-10T17:06:24Z","due_on":"2015-02-28T00:00:00Z","closed_at":null},"comments":18,"created_at":"2015-02-10T14:47:51Z","updated_at":"2015-02-10T18:01:06Z","closed_at":"2015-02-10T17:06:24Z","body":"I am running CC5216 and CC600b4 side-by-side, using the same webserver, PHP, and database (installed and populated starting at CC520 upgrading as required).\r\n\r\nViewing the Currency table in admin, CC5216 shows the various symbols, but CC006B4 shows question marks and white '? in black diamonds' for all foreign characters.\r\n\r\nSo, I think something isn't talking UTF-8 properly.\r\n\r\nI see that I am using a specially crafted CC5216 where this has been updated:\r\n```\r\nCC600B4: mysqli.class.php\r\n\t\t//Force UTF-8\r\n\t\t@mysqli_query($this->_db_connect_id, \"SET NAMES 'utf8'\");\r\n\t\t@mysqli_query($this->_db_connect_id, \"SET CHARACTER SET 'utf8'\");\r\nCC5216: mysqli.class.php\r\n\t\t//Force UTF-8\r\n\t\t//@mysqli_query($this->_db_connect_id, \"SET NAMES 'utf8'\");\r\n\t\t//@mysqli_query($this->_db_connect_id, \"SET CHARACTER SET 'utf8'\");\r\n\t\t@mysqli_set_charset($this->_db_connect_id, 'utf8');\r\nCC5216: mysql.class.php:\r\n\t\t@mysql_set_charset('utf8', $this->_db_connect_id);\r\n```\r\nI will switch up the CC6 code and report."},"comment":{"url":"https://api.github.com/repos/cubecart/v6/issues/comments/73749234","html_url":"https://github.com/cubecart/v6/issues/195#issuecomment-73749234","issue_url":"https://api.github.com/repos/cubecart/v6/issues/195","id":73749234,"user":{"login":"bhsmither","id":4073092,"avatar_url":"https://avatars.githubusercontent.com/u/4073092?v=3","gravatar_id":"","url":"https://api.github.com/users/bhsmither","html_url":"https://github.com/bhsmither","followers_url":"https://api.github.com/users/bhsmither/followers","following_url":"https://api.github.com/users/bhsmither/following{/other_user}","gists_url":"https://api.github.com/users/bhsmither/gists{/gist_id}","starred_url":"https://api.github.com/users/bhsmither/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/bhsmither/subscriptions","organizations_url":"https://api.github.com/users/bhsmither/orgs","repos_url":"https://api.github.com/users/bhsmither/repos","events_url":"https://api.github.com/users/bhsmither/events{/privacy}","received_events_url":"https://api.github.com/users/bhsmither/received_events","type":"User","site_admin":false},"created_at":"2015-02-10T18:01:06Z","updated_at":"2015-02-10T18:01:06Z","body":"Thanks Ian! We appreciate the insights."}}