Page 1 of 1

static page - no kyrillic letters

Posted: Fri Jun 14, 2013 7:48 pm
by Czorneboh
Hi all!

While kyrillic letters are displayed in dynamic pages, on static pages there are instead of the letters only questionsmarks.

I was searching in this thread, but it does not help me:
http://board.s9y.org/viewtopic.php?f=4& ... age#p40032

Perhaps I need only to change the configurations settings?
(But if so, why only so?)

The perhaps relevant settings are as follows:

1. use textformatting: no
2. format like blog entry: no
3. show pages of lower level: yes
...
8. show html meta input fields: yes
..


Can somebody tell, if the plugin should display the kyrillic letters with my actual configuration? Or is it a know issue already?
Any example of static pages with different languages than german and english available?

Czorneboh

Re: static page - no kyrillic letters

Posted: Thu Jun 20, 2013 10:09 am
by garvinhicking
Hi!

Maybe check your MySQL database table, see if the collation you have for the serendipity_entries.body column differs from those in serendipity_staticpages - maybe one is set to ISO and the other is set to unicode. It would be best to have them both match the same (working ;)) type.

HTH,
Garvin

Re: static page - no kyrillic letters

Posted: Thu May 29, 2014 10:01 pm
by Czorneboh
In static_pages there are several parts collocated with "latin1_swedish_ci".

articleformatting
pagetitle
permalink
content
pre_content
headline
filename
pass
language
title element
meta description
meta keywords

I am wondering about this.
I will change all those now all to "utf_8_unicode_ci".

With the first elements I had no problem, but with ...

"content"
"headline"

I have got a problem
failure message:

"#1283 - Column 'content' cannot be part of FULLTEXT index".

Trying to reset to "latin1_swedish_ci" I have got again the same MySQL-message here.

Now I do not know, what is the problem, as I am not familiar with MySQL.

Next I will try again writing kyrillic in the several fields and see, what happens.

Re: static page - no kyrillic letters

Posted: Mon Jun 02, 2014 9:51 am
by garvinhicking
Hey,

you might rather want to use utf8_general_ci. "Content" is part of a MySQL fulltext index. Usually changing the collation should not matter, but you may not change the type of the field, so make sure it is still set to "TEXT".

HTH,
Garvin