Recent Topics

RU language encoding problem in comments

Started by on Dec 08, 2013 – Contents updated: Dec 10, 2013

Dec 08, 2013 00:52    

hi friends,

I upgraded b2evo version from 3.3.3 to 5.0.6
and almost felt relief, until noticed that Russian language in COMMENTS not displaying properly.

Meanwhile the rest of the russian language content - in the BODY/POSTS - is all OK.

What might be done to repair russian language encoding in comments ?

example url: http://www.ant-sudak.ru/hotel/about-hotel/01

--
PS:

1. After cleaning CASHES and FIRST (F5) reload of page with COMMENTS - (RU)-comments display correctly.
But the next reload of page crashes comment again to broken symbols.

2. If I RESAVE (RU) comment - it displays correctly (on the first page load).
But the next reload of page crashes comment again to broken symbols.

hmm

Dec 08, 2013 19:23

FIXED

ok,
I tried this: http://forums.b2evolution.net/5-0-0-0-bug
and this: http://shininghappypeople.net/deljr/b2e-russian-english.html

and these helped me to find my own simple solution.

1.
I noticed, that after "Clear pre-renderered comment cache (DB)" (through b2evo/ admin.php) - my Cyrillic (Russian) comments are displayed properly just once, until the next reload.

2.
So I went to my HOSTING phpMyAdmin and found there TABLES responsible for COMMENTS PRE-RENDERING = evo_comments__prerendering.
For some reason its COLLATION was "latin1_swedish_ci" .
So I changed it manually to "utf8_general_ci" and now at last feel relief ).

Good luck to all !

Dec 08, 2013 19:30

Hello @acho,

I found some information that could work for you. You might start checking the collation and charset of your database, it's recomended to set all the database to UTF8, this could solve some wrong character issues as you reported. Please follow these links and tell us if they addresses your problem:

http://b2evolution.net/man/?s=utf8&disp=search&submit=Go
http://forums.b2evolution.net/topic-18952
http://forums.b2evolution.net/topic-20679

Regards!

Dec 10, 2013 09:21

Excellent @acho, thanks for sharing. I just realized you posted this before I sent my answer :)


Form is loading...

powered by b2evolution free blog software – This forum is powered by b2evolution CMS, a complete engine for your website.