Answers.Body: <p>Looks like you are using an older version of CiviCRM. If you upgrade to 4.7 then you will get the latest version of CKEditor.</p>
  
  <p>Or you could help review this issue to get it updated in 4.6LTS.
  <a href="https://github.com/civicrm/civicrm-packages/pull/166" rel="nofollow">https://github.com/civicrm/civicrm-packages/pull/166</a></p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-09-21T16:38:14.570Z
Answers.Text: Thanks Coleman, will do that - so the added characters is not an issue with Civi 4.7 because it runs a newer version of CKEditor ?
Answers.UserDisplayName: Joe McLaughlin
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-09-21T16:40:41.020Z
Answers.Text: And I'll take a crack at reviewing  https://github.com/civicrm/civicrm-packages/pull/166
Answers.UserDisplayName: Joe McLaughlin
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-09-21T17:19:58.970Z
Answers.Text: I'll check out CKEditor functionality on 4.7 on demo.
Answers.UserDisplayName: Joe McLaughlin
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-09-21T16:12:16.010Z
Answers.LastActivityDate: 2016-09-21T16:12:16.010Z
Answers.UserDisplayName: Coleman
Answers.Body: <p>That type of thing is normally character encoding problems. The first thing I'd check is what the character encoding on your database tables are, e.g.</p>
  
  <pre><code>SHOW CREATE TABLE civicrm_event;
  </code></pre>
  
  <p>If it says charset=latin1 or anything instead of utf-8 at the bottom then I'd guess that's your problem. You can see here for ways to fix it: <a href="https://stackoverflow.com/questions/2150256/how-to-change-all-the-tables-in-my-database-to-utf8-character-set">https://stackoverflow.com/questions/2150256/how-to-change-all-the-tables-in-my-database-to-utf8-character-set</a></p>
  
  <p>Edit: To save anyone reading all the comments, in this particular case it has something to do with ckeditor and character encoding. Workaround is use a different browser like firefox.</p>
  
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-09-21T02:17:17.540Z
Answers.Text: Demerit, thanks so much. Rather than trying to run mysql from the command line, will take a look at the tables and encoding using PHPMyAdmin.
Answers.UserDisplayName: Joe McLaughlin
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-09-21T02:57:18.307Z
Answers.Text: Commenting on your update, it sounds like you pasted from Word or something to create those pages, and there were bullets that are getting encoded incorrectly. If you create a similar page just by typing do you still get the problem?
Answers.UserDisplayName: Demerit
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-09-21T03:30:49.390Z
Answers.Text: Demerit - not positive but pretty sure the text was not created in Word but directly in CKEditor, will verify that - I wasn't the creator of the Event page. The extra "A" characters are not in the intro text source code in the civicrm_event table, which uses utf-8 encoding. See Update 2 above re using Firefox browser to edit the intro text source in Civi.
Answers.UserDisplayName: Joe McLaughlin
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-09-21T04:41:03.910Z
Answers.Text: Commenting on update 3: good sleuthing!
Answers.UserDisplayName: Demerit
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-09-21T04:47:36.210Z
Answers.Text: It doesn't seem to be "fixed" though and I read it as the html page needs to set the correct charset header? So not a problem with ckeditor but something in civi?
Answers.UserDisplayName: Demerit
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-09-21T05:07:48.887Z
Answers.Text: Demerit do you mean not fixed according to the CKEditor bug report? I did not the entire issue thread, mea culpa ;)
Answers.UserDisplayName: Joe McLaughlin
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-09-21T06:09:47.407Z
Answers.Text: Demerit, this is on the CKEditor issue page: "Awesome, thank you for checking!
  
  It turned out that the issue was caused by missing UTF-8 BOM marker at the beginning of ckeditor.js. After fixing the online builder, I have recreated all packages available for download. So in order to get rid of this bug it should be enough to download the CKEditor package again (with correct BOM character in all JavaScript files).
  "
Answers.UserDisplayName: Joe McLaughlin
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-09-21T12:59:57.923Z
Answers.Text: Civi 4.6 has ckeditor 4.0.1.1 and when I look at ckeditor.js I can see the BOM marker. But in any case if you keep reading that bug report it doesn't appear to actually be fixed for everybody. Civi 4.7 has ckeditor 4.5, but it sounds like the problem is something else.
Answers.UserDisplayName: Demerit
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-09-21T14:21:23.187Z
Answers.Text: Demerit thanks yeah the issue is definitely not totally fixed and relates to site encoding, browsers, browser versions and other factors. I'm using Firefox to edit our Event and other pages using CKEditor in Civi 4.6.21 as a temporary workaround.
Answers.UserDisplayName: Joe McLaughlin
Answers.ContentLicense: CC BY-SA 3.0
Answers.CreationDate: 2016-09-21T02:00:38.643Z
Answers.LastActivityDate: 2016-09-21T15:06:44.607Z
Answers.LastEditDate: 2017-05-23T12:38:59.763Z
Answers.UserDisplayName: Demerit
Body: <p>We're on Civi 4.6.21 and Drupal 7. </p>
  
  <p>We can't figure out why these characters - like Â Ã and Â -  appear in our Event pages. The text is not on the page we created, obviously, right in Civi. </p>
  
  <p>See the screenshots below - the first is <a href="https://my.citizenactionny.org/civicrm/event/info?id=771&amp;reset=1" rel="nofollow noreferrer">this page</a> in the Chromium browser on my laptop running Ubuntu.</p>
  
  <p>Any clues appreciated! </p>
  
  <p>UPDATE: The problem appears to be with the built-in version of CKEditor, see the second screenshot below. This code - <code>&amp;Acirc;</code> - keeps getting re-inserted in to the page intro text source on Save after being edited out. </p>
  
  <p>UPDATE 2: So - not sure why - and not a final fix - but editing the intro text source using Firefox, rather than Chrome, seems to take the weird characters out and not re-insert them on Save, pretty much. See the third screenshot below - the page after editing the source using Firefox, not Chrome. </p>
  
  <p>UPDATE 3: Here's the <a href="https://dev.ckeditor.com/ticket/9732" rel="nofollow noreferrer">CKEditor bug report</a> from <em>four years ago</em> about this issue, it was fixed three years ago...maybe it's time to update the CKEditor version in CiviCRM 4.6.X? Is there a newer version of CKEditor in CiviCRM 4.7.X ? </p>
  
  <p><a href="https://i.sstatic.net/22WQb.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/22WQb.png" alt="Chromium on Ubuntu"></a></p>
  
  <p><a href="https://i.sstatic.net/EorSr.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/EorSr.png" alt="CKEditor page"></a></p>
  
  <p><a href="https://i.sstatic.net/9588Q.png" rel="nofollow noreferrer"><img src="https://i.sstatic.net/9588Q.png" alt="Firefox edited"></a></p>
  
Tags: <civievent><drupal><ckeditor>
Title: Why do these characters - Â Ã Â - that were not added appear on Event registration pages created using CKEditor?
ThreadText: # Why do these characters - Â Ã Â - that were not added appear on Event registration pages created using CKEditor?
  
  (Asked by: username_0 on 2016-09-21)
  
  We're on Civi 4.6.21 and Drupal 7.
  
  We can't figure out why these characters - like Â Ã and Â - appear in our Event pages. The text is not on the page we created, obviously, right in Civi.
  
  See the screenshots below - the first is [this page](https://my.citizenactionny.org/civicrm/event/info?id=771&reset=1) in the Chromium browser on my laptop running Ubuntu.
  
  Any clues appreciated!
  
  UPDATE: The problem appears to be with the built-in version of CKEditor, see the second screenshot below. This code - `Â` - keeps getting re-inserted in to the page intro text source on Save after being edited out.
  
  UPDATE 2: So - not sure why - and not a final fix - but editing the intro text source using Firefox, rather than Chrome, seems to take the weird characters out and not re-insert them on Save, pretty much. See the third screenshot below - the page after editing the source using Firefox, not Chrome.
  
  UPDATE 3: Here's the [CKEditor bug report](https://dev.ckeditor.com/ticket/9732) from *four years ago* about this issue, it was fixed three years ago...maybe it's time to update the CKEditor version in CiviCRM 4.6.X? Is there a newer version of CKEditor in CiviCRM 4.7.X ?
  
  [![Chromium on Ubuntu](https://i.sstatic.net/22WQb.png)](https://i.sstatic.net/22WQb.png)
  
  [![CKEditor page](https://i.sstatic.net/EorSr.png)](https://i.sstatic.net/EorSr.png)
  
  [![Firefox edited](https://i.sstatic.net/9588Q.png)](https://i.sstatic.net/9588Q.png)
  
  **Tags:** civievent, drupal, ckeditor
  
  
  ---
  
  ## 2 answers
  
  ### Answer by username_1 on 2016-09-21. Score: 1 | Accepted answer
  
  Looks like you are using an older version of CiviCRM. If you upgrade to 4.7 then you will get the latest version of CKEditor.
  
  Or you could help review this issue to get it updated in 4.6LTS.
  <https://github.com/civicrm/civicrm-packages/pull/166>
  
  > **Comments:**
  > **username_0**: Thanks username_1, will do that - so the added characters is not an issue with Civi 4.7 because it runs a newer version of CKEditor ?  
  > **username_0**: And I'll take a crack at reviewing  https://github.com/civicrm/civicrm-packages/pull/166  
  > **username_0**: I'll check out CKEditor functionality on 4.7 on demo.  
  
  ---
  
  ### Answer by username_2 on 2016-09-21. Score: 1
  
  That type of thing is normally character encoding problems. The first thing I'd check is what the character encoding on your database tables are, e.g.
  SHOW CREATE TABLE civicrm_event;
  
  If it says charset=latin1 or anything instead of utf-8 at the bottom then I'd guess that's your problem. You can see here for ways to fix it: https://stackoverflow.com/questions/2150256/how-to-change-all-the-tables-in-my-database-to-utf8-character-set
  Edit: To save anyone reading all the comments, in this particular case it has something to do with ckeditor and character encoding. Workaround is use a different browser like firefox.
  
  > **Comments:**
  > **username_0**: username_2, thanks so much. Rather than trying to run mysql from the command line, will take a look at the tables and encoding using PHPMyAdmin.  
  > **username_2**: Commenting on your update, it sounds like you pasted from Word or something to create those pages, and there were bullets that are getting encoded incorrectly. If you create a similar page just by typing do you still get the problem?  
  > **username_0**: username_2 - not positive but pretty sure the text was not created in Word but directly in CKEditor, will verify that - I wasn't the creator of the Event page. The extra "A" characters are not in the intro text source code in the civicrm_event table, which uses utf-8 encoding. See Update 2 above re using Firefox browser to edit the intro text source in Civi.  
  > **username_2**: Commenting on update 3: good sleuthing!  
  > **username_2**: It doesn't seem to be "fixed" though and I read it as the html page needs to set the correct charset header? So not a problem with ckeditor but something in civi?  
  > **username_0**: username_2 do you mean not fixed according to the CKEditor bug report? I did not the entire issue thread, mea culpa ;)  
  > **username_0**: username_2, this is on the CKEditor issue page: "Awesome, thank you for checking!  It turned out that the issue was caused by missing UTF-8 BOM marker at the beginning of ckeditor.js. After fixing the online builder, I have recreated all packages available for download. So in order to get rid of this bug it should be enough to download the CKEditor package again (with correct BOM character in all JavaScript files). "  
  > **username_2**: Civi 4.6 has ckeditor 4.0.1.1 and when I look at ckeditor.js I can see the BOM marker. But in any case if you keep reading that bug report it doesn't appear to actually be fixed for everybody. Civi 4.7 has ckeditor 4.5, but it sounds like the problem is something else.  
  > **username_0**: username_2 thanks yeah the issue is definitely not totally fixed and relates to site encoding, browsers, browser versions and other factors. I'm using Firefox to edit our Event and other pages using CKEditor in Civi 4.6.21 as a temporary workaround.  
  
  ---
  
  