Danish charset

Hi,

In the left side of the picture, you will see my menu, where the subcategory is not displaying its correct danish letter (We mainly use “æ,ø,å”, where “æ” is the one failing here). no problem, when i use those letters in page.tpl etc. but doesnt work, when its within the categories. Why? i tryed adding ‘charset’ => ‘utf-8’, to all the files in the /da folders. which specific file do i need to add it to? have deleted /tmp content, “!update db views”, added translit_lang.php and deleted cookies etc.

The right side of the picture, is how it should look like

[B]Conclusion: All tables in database should be set to utf8_general_ci(did that with notepad++) and config.inc.php -> $this->iUtfMode = 1[/B]
Edit: The website will show the special letters, with only changing the config.inc.php

It’s important, that the file itself is also saved in utf-8… You can see this more advanced Editors like notepad++ or something similar…

Thanks for the reply.
It didnt work. all of the files in translations / da … views / admin … views / <childtheme> / da
is changed to utf-8 in both charset and encoding

Did you check the special chars after converting the files? Do the special chars still appear correctly in the editor?

The specials chars looks fine in the notepad++ plus at the website, but not in the categories - which languagefile are they being made in? the only spot at the site, where these chars is not being show corretly, is in the category-menu

If this is a name (=title) of a category, you should look for errors in the character encoding in the database because this value comes from the DB.

@martin.wegele
thanks for you reply. I looked in the db and it had latin1_general_ci collation in all the tables. i tryed to change it from my hosts phpMyAdmin(3.5.5…), but i wasnt able to do it. Maybe i did it wrong(new to all this), but it only worked at some places in there. So i export it all and went into notepad++ and replaced all lating1 = utf8. So you will see utf8_general_ci in the database. Importet it again and they where all changed. But its still not working?
oxcategories [B]=[/B] utf8_general_ci

which shop version?

@Hebsacker
4.7.4_57063

maybe this one helps:

This is getting close to confusing for me. well, @Hebsacker, i didnt get to run your suggestions, i found a guide, on how to install it, but i noticed, they wrote something about config.inc.php -> $this->iUtfMode = … i then tryed setting it to 1(was 0 before.)… and then everything so far, is working…

Then for the fun of it, i tryed setting my database back, to when it used latin1_general_ci in the tables and that also worked, as long as i used iUtfMode = 1, BUT, then i wasnt able to login to /admin, it said something with wrong user. why is that? and what do i do in the future, if something like that happens? is this being logged? if i then changed it back to iUtfMode = 0, then i could login again…

[B]Conclusion: All tables in database should be set to utf8_general_ci(did that with notepad++) and config.inc.php -> $this->iUtfMode = 1[/B]
Edit: The website will show the special letters, with only changing the config.inc.php and latin1_general_ci in db. but wont allow me to login to /admin

yes - it is a problem to log in if the database has a different collation than the values in the fields have

http://forum.oxid-esales.com/showthread.php?t=17893#post114184

Thanks. Does oxid log this somewhere? and if my store goes offline etc. will it log these things, so debugging becomes more easy?

bump…

have a look at D3 Modulkonnektor - it has a convenient logging function