Collation is wrong, or something, swedish characters showing as � questionmarks in rombs.: PHPFusion 8 Support

Home
Search

Oh no! Where's the JavaScript?
Your Web browser does not have JavaScript enabled or does not support JavaScript. Please enable JavaScript on your Web browser to properly view this Web site, or upgrade to a Web browser that does support JavaScript.

I am trying to help this guy setting up a new fusion site on the very same server where we used to run php-fusion.se
. I never had any issues with using a swedish PHPFusion. The general DB Collation has always been utf-8 and inside the tables it has been latin1_swedish. Always worked for me. Also on a brand new site on another server I can setup php-fusion with Swedish locales and it works.

But not for this one. Whenever I switch to Swedish all å ä ö characters are turned in to � See image, the question mark inside a romb.

We use the same settings in global.php as usual:

Code Download source

// Locale Settings
setlocale(LC_TIME, "swedish"); // Linux Server (Windows may differ)
$locale['charset'] = "iso-8859-1";
$locale['xml_lang'] = "sv";
$locale['tinymce'] = "en";
$locale['phpmailer'] = "en";

but it does not seem to have effect. Running the site in English gives no errors that i can see (it is a brand new setup).
PHP 5.6.4

Any tips...?

Edited by Homdax on 17-01-2015 11:24, 10 y

Homdax attached the following file:

screenshot269.jpg [No information available / 105 Downloads]

replacement_character.png [No information available / 108 Downloads]

0 replies

OTF8+ BOM thingie...? I thought it was relevant only for future releases of fusion... seems it is a global ****fest.

Anyway, on it http://stackoverflow.com/questions/5378522/utf-8-without-bom lets see if it helps...

0 replies

OK, converted the files and this works, ALMOST. admin/main.php has some entries that won't allow for correction. I have no clue why.

I found this little utility that is a bit buggy but actually converted all files (by folder) correctly as verified in other software later. http://sourceforge.net/projects/cp-converter/ .

0 replies

This is a big problem to me :x http://www.hellasplus.com/infusions/f...p?cat_id=2

I do not believe to be the language problemme is subject code probleme not correct written for uttf8 I do not know that

certainly not from files of the language ;)

Code Download source

// Locale Settings  &#932;&#959;&#960;&#953;&#954;&#941;&#962; &#961;&#965;&#952;&#956;&#943;&#963;&#949;&#953;&#962;
setlocale(LC_TIME, "el","GR"); // Linux Server (Windows may differ)
$locale['charset'] = "UTF-8";
$locale['xml_lang'] = "el";
$locale['tinymce'] = "el";
$locale['phpmailer'] = "el";

0 replies

The I think you need to resave the files. The code in the language files is not the issue, it is the "encoding" of them. Sen me the files, I can have a look, it is very simple now that I know what to look for.

http://en.wikipedia.org/wiki/Character_encoding
http://en.wikipedia.org/wiki/UTF-8

Greek? http://el.wikipedia.org/wiki/%CE%9A%CF%89%CE%B4%CE%B9%CE%BA%CE%BF%CF%80%CE%BF%CE%AF%CE%B7%CF%83%CE%B7_%CF%87%CE%B1%CF%81%CE%B1%CE%BA%CF%84%CE%AE%CF%81%CF%89%CE%BD

0 replies

you want all the files from the language ? hiar http://www.hellasplus.com/upload/inde...ion%20lang the problem exists in paners mod infusion generally at unfinished words

top 10 news top 10 Articles paners mods I put all have problems in utf8 , the home news.php Everything is OK

below is what you showed greek lang fusion tube

dimki attached the following file:

greek.rar [No information available / 310 Downloads]

0 replies

It looked ok, but I resaved it again.
See if there is any difference.

UTF8 without BOM.

Homdax attached the following file:

greek-utf8.rar [No information available / 293 Downloads]

0 replies

Falk

answered 18 Jan 2015 at 01:32 PM

Super Admin

It will only become an issue if you have database tables with UTF-8 and not the propper encodings for it, you should not mix tables and charsets.
For Swedish sites you can use latin1_swedish_ci and it will work with current locale files.

If you use UTF-8 tables you should also updated the global.php locale to

Code Download source

setlocale(LC_TIME, "sv_SE.utf8"); // Linux Server (Windows may differ)
$locale['charset'] = "UTF-8";

You can read some about UTF-8 here

0 replies

So if I use "General collation" in the database as UTF-8 and "table collation" as Latin1 in the tables, for varchar and text, that combination is wrong?

0 replies

the same
so I do not think it is a question of language B)

maybe something will be changed the code from paners I have no idea :(

if the problem from database I do not think I will make a foto

0 replies

Falk