Go into myphpadmin to your database and see the GDN_Comments table, there is a column called Collation , it should say utf 8 for the charset, what do you have ?
I posted a test in your forum to see what it did if I changed my browser character encoding, I did not get the question marks, but some letters were changed into greek letters.
This has nothing to do with the editor itself in my opinion.
It is also similar to the htmlawed file missing from a user folder and the markup would show, notice how the div shows in that comment.
Disable the editor so only the default is on and see if it also happens, I bet it does...But would like to be proven wrong but this has to do with parsing...
So not shure, but i think it's an CLEditor issue... and because of that, I'm wondering why nobody else has these issues... or am I the only one using CLEditor?? hehe... ))
Indeed .But how to change the posts that are saved except by hand.
@peregrine said:
he said in a prior message unless i am confused that the error did not occur in other editors!
but I have no other ideas - so I'll stop running intercepts.
He said it happened with tinyMCE also. But did not say it happened with default editor.
I would dump the whole cleditor plugin and get a fresh copy from the github repo.
All I can think of is that MyISAM is defined as type or as engine depending on the version. Maybe it is a red herring after all, since it works with the default editor.
ok... lets go listen to the cushion... ))
Now I know some more where to look and what to change, so I'll do that after a Pachty Weekend.. ))
I'll also try a fresh setup and look for differences....
@Dr_Sommer said:
BUT... the spaces are shrink together!! if I put 6 Spaces between text, it shrinks to one!! if I enter , it shows the "questionmarks"
This is correct for raw html. Only editors may add non breaking spaces.
This is really incredible... i was searching for Months for this error...
Now it seems, that the EMOTIFY Plugin is the problem!!!
I could Shoot myself, but I am sure, that I disabled ALL Plugins for testing purposes...
Maybe its because Emotify 1.0 is not having this issues (but others) and V2.0.5. does....
I deinstalled my Green Smilies Version of Emotify and put the original Emotify 2.0.5 Plugin... same errors as before... if I switch it off or use V1.0, there are no more "Question marks"...
Crazy, Crazy... but I'm glad that I've found it...
Thanks again to you all, I'll address this error in the Plugin Section of Emotify...
I had a similar issue. After reading this, I confirmed it had to do with writing no break spaces to the database. I simply replaced all no break spaces with spaces on submit to solve the problem.
Comments
Go into myphpadmin to your database and see the GDN_Comments table, there is a column called Collation , it should say utf 8 for the charset, what do you have ?
❌ ✊ ♥. ¸. ••. ¸♥¸. ••. ¸♥ ✊ ❌
Have a Table called GDN_comment, no collation column there:
I hope you are right V. and that it not a red herring
I still don't see why would it be mysql -
if characters works in other editors on his site with <meta charset="utf-8"> in header with the same database?
it seems that cleditor is still at fault not database.
I may not provide the completed solution you might desire, but I do try to provide honest suggestions to help you solve your issue.
I posted a test in your forum to see what it did if I changed my browser character encoding, I did not get the question marks, but some letters were changed into greek letters.
This has nothing to do with the editor itself in my opinion.
It is also similar to the htmlawed file missing from a user folder and the markup would show, notice how the div shows in that comment.
Disable the editor so only the default is on and see if it also happens, I bet it does...But would like to be proven wrong but this has to do with parsing...
❌ ✊ ♥. ¸. ••. ¸♥¸. ••. ¸♥ ✊ ❌
Im not shure (was some time ago), but when I use vrijvlinders TinyMCEFour, I don't have these issues... but others..
http://vanillaforums.org/discussion/25398/not-visible-in-2-1-b2#latest
So not shure, but i think it's an CLEditor issue... and because of that, I'm wondering why nobody else has these issues... or am I the only one using CLEditor?? hehe...
))
I'll now turn CLEditor off...
he said in a prior message unless i am confused that the error did not occur in other editors!
but I have no other ideas - so I'll stop running intercepts.
I may not provide the completed solution you might desire, but I do try to provide honest suggestions to help you solve your issue.
when off, no errors occurred...
BUT... the spaces are shrink together!! if I put 6 Spaces between text, it shrinks to one!! if I enter
, it shows the "questionmarks"only other thought is try <meta charset="UTF-8"> in all of the places in js file and where else you put it.
and make changes in jquery.cleditor.js
and change
$Sender->AddJsFile('jquery.cleditor'.(Debug() ? '' : '.min').'.js', 'plugins/cleditor', $Options); to $Sender->AddJsFile('jquery.cleditor.js', 'plugins/cleditor', $Options);and just to see what happens with this.... it might break other things - but if ?'s go away you know where the issues is.
I may not provide the completed solution you might desire, but I do try to provide honest suggestions to help you solve your issue.
Indeed .But how to change the posts that are saved except by hand.
He said it happened with tinyMCE also. But did not say it happened with default editor.
I would dump the whole cleditor plugin and get a fresh copy from the github repo.
All I can think of is that MyISAM is defined as type or as engine depending on the version. Maybe it is a red herring after all, since it works with the default editor.
❌ ✊ ♥. ¸. ••. ¸♥¸. ••. ¸♥ ✊ ❌
ok... lets go listen to the cushion...
))
))
Now I know some more where to look and what to change, so I'll do that after a Pachty Weekend..
I'll also try a fresh setup and look for differences....
THANK YOU BOTH VERY MUCH... :* :* :*
This appears to happen due to empty space according to this :
http://dev.ckeditor.com/ticket/8704
Here is some related links to similar issues with the html editor
http://stackoverflow.com/questions/241015/question-mark-characters-displaying-within-text-why-is-this
http://www.webassist.com/forums/posts.php?id=31292
http://www.vbulletin.com/forum/forum/vbulletin-4/vbulletin-4-questions-problems-and-troubleshooting/412168-ckeditor-choking-on-some-special-characters
http://stackoverflow.com/questions/1461907/html-encoding-issues-character-showing-up-instead-of-nbsp
http://www.w3.org/International/questions/qa-byte-order-mark.en.php
http://codex.wordpress.org/Converting_Database_Character_Sets
❌ ✊ ♥. ¸. ••. ¸♥¸. ••. ¸♥ ✊ ❌
This is correct for raw html. Only editors may add non breaking spaces.
grep is your friend.
Also I think in the table it should say utf8_general_ci Instead of utf8_unicode_ci
❌ ✊ ♥. ¸. ••. ¸♥¸. ••. ¸♥ ✊ ❌
This is really incredible... i was searching for Months for this error...
Now it seems, that the EMOTIFY Plugin is the problem!!!
I could Shoot myself, but I am sure, that I disabled ALL Plugins for testing purposes...
Maybe its because Emotify 1.0 is not having this issues (but others) and V2.0.5. does....
I deinstalled my Green Smilies Version of Emotify and put the original Emotify 2.0.5 Plugin... same errors as before... if I switch it off or use V1.0, there are no more "Question marks"...
Crazy, Crazy... but I'm glad that I've found it...
Thanks again to you all, I'll address this error in the Plugin Section of Emotify...
I had a similar issue. After reading this, I confirmed it had to do with writing no break spaces to the database. I simply replaced all no break spaces with spaces on submit to solve the problem.
Here is another solution, rdebruyn:
http://vanillaforums.org/discussion/25911/obscure-formating-errors-cleditor-emotify-plugin#latest
