Indexhibit Support

I don't seem to display accents in my projects. I can see them in the input window but I can't see them in the project window... for instance "são" comes up as são.

Thank you

This is a bug that we can't always fix...your database has incorrect encoding. You need to go into your database with PHPMyAdmin and change all the collation valuse for database, tables AND individual cells from Latin1 to utf8-general-ci.

Hi there!
I got the same problem.
I already changed all the collations that were given into utf8_general_ci but still, the german characters like äöü are displayed like: öüä
The thing is, when I change the firefox encodiung from automatic to unicode it works, but firefox won't do it automatically... what to do?
here is a link to have a look (site still under construction): click

Did you go back to the cms...re-enter those characters and then save them again?

Also, you need to be sure that both the columns AND the tables are utf8.

yes i did that.
i think the problem is that the browser doesnt switch the charset automatically.

do i need to change all the columns or just the ones that already had a collation?

thanks, flo

No, it's not the browser...don't even consider the browser. It's the tables AND the columns - all of them.

I can put umlauts onto things on my site no problem.

alright...
i dont get it... i really changed all tables and columns to utf 8 general ci but still it's displayed as iso 8859 1.

this is what phpMyAdmin tells me (if that can help?):

character set client utf8
(Globaler Wert) latin1
character set connection utf8
(Globaler Wert) latin1
character set database latin1
character set filesystem binary
character set results utf8
(Globaler Wert) latin1
character set server latin1
character set system utf8
character sets dir /usr/share/mysql/charsets/
collation connection utf8_general_ci
(Globaler Wert) latin1_swedish_ci
collation database latin1_swedish_ci
collation server latin1_swedish_ci

Yes...I understand...this annoys me greatly too. I'm not even sure where MySQL and/or PHPMyAdmin made all of this so mixed up but it happened about six months ago. I need to research this later to understand...

You are unable to set the table collation?

Ask your host about this...they aren't doing you any favors with these settings above (and they are beyond the grasp of Indexhibit).

hey.
just to let you guys know how I solved it. No good answer from the host so I tried a bit around.
Now I added the following line to the common.php - file:

header('content-type: text/html; charset=utf-8');

and it works. it kinda forces the browser to display the site as utf-8.

flow your trick worked very very well!!

this should be included on next release!

No it shouldn't...it's not a real solution...fixing the database is the real way to fix this.