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. Collation is wrong, or something, swedish characters showing as � questionmarks in rombs.
Start New Thread

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


Print Track
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 / 28 Downloads]
replacement_character.png [1.33kB / 28 Downloads]

11 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...
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/ .
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";
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
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 / 241 Downloads]
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 / 227 Downloads]
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
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?
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
No, but if you use UTF-8 files and UTF-8 charset definitions on latin tables it is.
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
author Homdax
forumInstallation Issues - 8
replies12 posts
viewed2957 times
activeLast updated on 5 years ago

Related

My Recent Posts & My Recent Threads
Started by
J
Joe Kriz - 14 posts
News.php & news_cats.php together
Started by
X
xdenama - 3 posts
Changing Content-Type & Content-Language will affect anywhere?
Started by Ankur Ankur - 1 post
Cant delete or edit config.php & index.php
Started by
A
amex - 6 posts
PANEL SNIPPIT:: Affiliates & Friends Panel
Started by Craig Craig - 3 posts
PHP-Fusion Project Portal - Free & Paid PHP-Fusion Projects
Started by FreedomIOPList FreedomIOPList - 1 post

Hot Questions

KFJ
UTF-8
KFJ - 20 posts
X
HHAVE TO CHECK REMEMEBER ME BOX TO LOG ON
xpftp - 37 posts
K
Cannot access administration after login
KimGregersen - 27 posts
River66
IE7 hangs on my new Fusion 7
River66 - 23 posts
I
Image list in tinymce doesnt work anymore
Ivoht - 26 posts
M
Fatal error: require_once(): Failed opening required 'includes/classes/PasswordAuth.class.php
markedwards - 8 posts
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.
Users who participated in discussion: Falk, Homdax, dimki