Russian and Chinese characters in evo1.4.17 with tinymce

user451

Hi evos

We have a evo1.4.17 site and it uses tinymce editor on all information web pages and we wanted to get Chinese and Russian characters working on a few pages so we added:

"
市中心。它也充满了一流的酒吧、餐馆和活动。
我们家门口就有您需要的各种便利设施，使 l 成为您游览都柏林时的理想下榻之所。

Приходите и наслаждайтесь:
Бесплатный свежезаваренный чай и кофе с печеньем в течение дня.
Бесплатный высокоскоростной Wi-Fi и кабельный доступ в Интернет во всех номерах и на всей территории отеля.
Охраняемая автостоянка. Плата за парковку составляет 10 евро за автомобиль в сутки. Парковка предоставляется в зависимости от наличия возможности в порядке живой очереди.
Короткая прогулка до центра Дублина и его основных достопримечательностей
Отличное транспортное сообщение с автобусным маршрутом прямо у нашего парадного входа и всего в нескольких ми
"

to the text in tinmyce in a test page and we can cut'n'paste that text into tinymce editor, and it displays, but as soon as we save the page, all characters change to "???????????? ???????????????????....." characters.

Can anyone advise how we can get these characters to display and save correctly?

we have the EVO-->config-->"interface & features" setting called "Character encoding" set to "unicode utf8" but that is not fixing this.

any help would be much appreciated

user451

there are a number of settings in the tinymce plugin panel - are they supposed to be set in a particular way?

i also tried putting these characters "市中心。它也充满了一Приходите и наслаждайтесь" into a chunk and putting that into a web pages and those are displaying as "?????????? ?????????.........." too, so it could be a database issue?

in evo1.4.17 settings , we have "Database Collation Charset latin1_swedish_ci" --- so should that be "unicode-utf8"? if so, where is that set? in mysql in phpmyadmin ?

i checked in /manager/includes/config.inc.php and it is set as "$database_connection_charset = 'utf8';" --- is that what you use?

user451

hi @Pathologic - what evo1.4.17 setup do you use to display russian characters? do you need a special character-set for mysql? or special settings in evo-->config?

fourroses666

I don't know but maybe its a .htaccess thing.
https://forum.evo.im/d/223-special-characters-dont-work-on-server

user451

i tried your 2 (below) already thanks Marc. neither worked in my scenario. i spoke to vps hoster and the default charset for a new mysql 5.7 install is still not utf8*** for russian/Chinese characters. the default is less than that so it refuses all russian/chinese chars. he suggested i run "ALTER TABLE XXXXXX CONVERT TO CHARACTER SET utf8" on each table that will have russian/chinese chars and it should receive them then. will try asap

###########################
.htaccess AddDefaultCharset UTF-8
<meta http-equiv="Content-type" content="text/html; charset=UTF-8">