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.
Sign In
Not a member yet? Click here to register.
Forgot Password?
Navigation
Discussion Forum
  1. Home
  2. Discussion Forum
  3. PHP-Fusion 8 Support
  4. Installation Issues - 8
  5. Collation is wrong, or something, swedish characters showing as � questionmarks in rombs.
Homdax

Collation is wrong, or something, swedish characters showing as � questionmarks in rombs.

by Homdax, Last updated on 4 years ago in Installation Issues - 8
Sort By: Oldest
Track Print
Start New Thread
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 PHP-Fusion. 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...?
Homdax attached the following file:
screenshot269.jpg [54.59kB / 13 Downloads]
replacement_character.png [1.33kB / 13 Downloads]
Need help? Having trouble?
» View our Documentation for guides, functions and more - including the Getting Started section!
» Attach Log Files and Screenshots when reporting issues
» Name and Organize your content correctly for best results - use good grammar

Who the hell thought "erectus" was a good species name for our ancestors?
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...
Need help? Having trouble?
» View our Documentation for guides, functions and more - including the Getting Started section!
» Attach Log Files and Screenshots when reporting issues
» Name and Organize your content correctly for best results - use good grammar

Who the hell thought "erectus" was a good species name for our ancestors?
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/ .
Need help? Having trouble?
» View our Documentation for guides, functions and more - including the Getting Started section!
» Attach Log Files and Screenshots when reporting issues
» Name and Organize your content correctly for best results - use good grammar

Who the hell thought "erectus" was a good species name for our ancestors?
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  Τοπικές ρυθμίσεις

setlocale(LC_TIME, "el","GR"); // Linux Server (Windows may differ)

$locale['charset'] = "UTF-8";

$locale['xml_lang'] = "el";

$locale['tinymce'] = "el";

$locale['phpmailer'] = "el";
Download themes http://www.hellasplus.com/themes_page...index.html DEMO 9http://fusion9.hellasplus.com/
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
Need help? Having trouble?
» View our Documentation for guides, functions and more - including the Getting Started section!
» Attach Log Files and Screenshots when reporting issues
» Name and Organize your content correctly for best results - use good grammar

Who the hell thought "erectus" was a good species name for our ancestors?
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 [5.26kB / 228 Downloads]
Download themes http://www.hellasplus.com/themes_page...index.html DEMO 9http://fusion9.hellasplus.com/
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 [5.28kB / 215 Downloads]
Need help? Having trouble?
» View our Documentation for guides, functions and more - including the Getting Started section!
» Attach Log Files and Screenshots when reporting issues
» Name and Organize your content correctly for best results - use good grammar

Who the hell thought "erectus" was a good species name for our ancestors?
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
Need help?, Having trouble?
• View our Documentation for Guides, Standards and Functions
• Name and Organize your content correctly in the corresponding Forums for best support results
• Attaching Log Files and Screenshots when reporting issues will help
• Please read and comply with the Code of Conduct

(¯`·._.·(¯`°·._.·°º*[ Project Manager ]*º°·._.·°´¯)·._.·´¯)
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?
Need help? Having trouble?
» View our Documentation for guides, functions and more - including the Getting Started section!
» Attach Log Files and Screenshots when reporting issues
» Name and Organize your content correctly for best results - use good grammar

Who the hell thought "erectus" was a good species name for our ancestors?
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
Download themes http://www.hellasplus.com/themes_page...index.html DEMO 9http://fusion9.hellasplus.com/
No, but if you use UTF-8 files and UTF-8 charset definitions on latin tables it is.
Need help?, Having trouble?
• View our Documentation for Guides, Standards and Functions
• Name and Organize your content correctly in the corresponding Forums for best support results
• Attaching Log Files and Screenshots when reporting issues will help
• Please read and comply with the Code of Conduct

(¯`·._.·(¯`°·._.·°º*[ Project Manager ]*º°·._.·°´¯)·._.·´¯)
I have no idea of the :| database is fine

www6.picfront.org/picture/MozRJPDfHi7/thb/Unbenanjhjhnt.PNG www14.picfront.org/picture/oYnbeu1S/thb/Unbenannt.PNG
Download themes http://www.hellasplus.com/themes_page...index.html DEMO 9http://fusion9.hellasplus.com/
You can view all discussion threads in this forum.
You can start a new discussion thread in this forum.
You cannot reply in this discussion thread.
You cannot start on a poll in this forum.
You cannot upload attachments in this forum.
You can download attachments in this forum.