static page - no kyrillic letters

Creating and modifying plugins.
Post Reply
Czorneboh
Regular
Posts: 381
Joined: Tue Apr 08, 2008 7:17 pm
Location: Berlin
Contact:

static page - no kyrillic letters

Post by Czorneboh » Fri Jun 14, 2013 7:48 pm

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

User avatar
garvinhicking
Core Developer
Posts: 30014
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: static page - no kyrillic letters

Post by garvinhicking » Thu Jun 20, 2013 10:09 am

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
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/

Czorneboh
Regular
Posts: 381
Joined: Tue Apr 08, 2008 7:17 pm
Location: Berlin
Contact:

Re: static page - no kyrillic letters

Post by Czorneboh » Thu May 29, 2014 10:01 pm

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.

User avatar
garvinhicking
Core Developer
Posts: 30014
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: static page - no kyrillic letters

Post by garvinhicking » Mon Jun 02, 2014 9:51 am

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
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/

Post Reply