viper357
07-21-2014, 08:18 AM
I'm starting to have an issue on my forum (3.8.5) whereby some posts are having certain characters being changed, things like ', ", - are being changed into this:
***8220;Success is stumbling from failure to failure with no loss of enthusiasm.***8221;
***8213; Winston Churchill Whereas it should be:
"Success is stumbling from failure to failure with no loss of enthusiasm."
- Winston Churchill But it's not happening to all posts, only some. I've been searching the net and reading on vb.com but it's above my understanding. I have picked up on what I think may be the problem, but I don't know, and that's the character setting? Here are some screenshots that I have taken after reading various threads on vb.com
Can anybody see anything wrong anywhere? Thanks. :)
This is one of the posts:
https://vborg.vbsupport.ru/external/2014/07/12.jpg
The settings on the first page at phpmyadmin
https://vborg.vbsupport.ru/external/2014/07/13.jpg
The collation column when I select my database in phpmyadmin
https://vborg.vbsupport.ru/external/2014/07/14.jpg
The Character set in vb admincp
https://vborg.vbsupport.ru/external/2014/07/15.jpg
Character set and collation from vb admincp
https://vborg.vbsupport.ru/external/2014/07/16.jpg
I don't really know what any of this all means so hoping someone can pick up on something that is incorrect?
For the time being I have had to use the Replacement Variable Manager to fix this, but I'd prefer to fix the issue properly, thank you. :)
***8220;Success is stumbling from failure to failure with no loss of enthusiasm.***8221;
***8213; Winston Churchill Whereas it should be:
"Success is stumbling from failure to failure with no loss of enthusiasm."
- Winston Churchill But it's not happening to all posts, only some. I've been searching the net and reading on vb.com but it's above my understanding. I have picked up on what I think may be the problem, but I don't know, and that's the character setting? Here are some screenshots that I have taken after reading various threads on vb.com
Can anybody see anything wrong anywhere? Thanks. :)
This is one of the posts:
https://vborg.vbsupport.ru/external/2014/07/12.jpg
The settings on the first page at phpmyadmin
https://vborg.vbsupport.ru/external/2014/07/13.jpg
The collation column when I select my database in phpmyadmin
https://vborg.vbsupport.ru/external/2014/07/14.jpg
The Character set in vb admincp
https://vborg.vbsupport.ru/external/2014/07/15.jpg
Character set and collation from vb admincp
https://vborg.vbsupport.ru/external/2014/07/16.jpg
I don't really know what any of this all means so hoping someone can pick up on something that is incorrect?
For the time being I have had to use the Replacement Variable Manager to fix this, but I'd prefer to fix the issue properly, thank you. :)