URL to your eFiction: http://fel.tym.cz/eFiction/
Version of eFiction: 3.4.3
Have you bridged eFiction, if so with what?: no
Version of PHP: 5.2.0
Version of MySQL: 5.0
Have you searched for your problem: yes
If so, what terms did you try: utf8, utf-8, set names utf8, charset, title character, wrong charset and similar
State the nature of your problem:
Wrong characters displaying:
when editing a story. The title of the story or chapter is displayed probably in iso-8859-1.
when choosing a category anywhere (browsing stories, editing a story) after click
See the image:
Do you have a test account for us? user: efic password: efic
What i do?
I create my own language file with utf8 charset. (now i set it for you to en.php with utf8 charset)
I edit mysqli_functions.php and add these lines above return line:
mysqli_query($mysql_access, "SET NAMES 'utf8'");
mysqli_query($mysql_access, "SET CHARACTER SET utf8");
I edit mysql_functions.php and add these line above return line:
mysql_query("SET NAMES 'utf8'");
mysql_query("SET CHARACTER SET utf8");
Data are stored in mysql in utf8 (I see correct characters in PHPmyAdmin).
I use recode command under linux to change files to utf8:
find . -iname '*.php' -exec recode iso-8859-1..utf8 {} ;
find . -iname '*.tpl' -exec recode iso-8859-1..utf8 {} ;
You need to redefine the character set for the entire site. It's in the language file, en.php by default.
