Indexhibit^TM
Index + Exhibit

Hi!

I have found out, that uploading files with containing socalled "umlaute" in the filename produces an error with some kind of a "romanize-function".

Is that a known issue, or can I use the ö, ä, ü, ß in filenames somehow?

Thanks!

The issue is with your database...check it and all the tables and columns using PHPMyAdmin and if they are Latin1 change them to utf8.

That was it! Thanks, Vaska!

Hi, is this also causing the problem with symbols such as & in section titles?

Hmmm...I think an & would work in a section title. It's not working for you?

I have the same problem with Umlaute (ü, ä, ö) and Symbols (&,…,–).

Actually, it doesn't seem to be a DB problem (it is set on UTF-8). I can see Umlaute and Symbols when editing my site, but those characters are not displayed in the front end.

Any suggestions anyone? Thanks a lot!

Read the above posts...that's the problem. Have you checked every table and every column?

Of course, I have read the above posts. And yes, I have checked every table and every column.

Since I can see those symbols and umlauts in the editing part of the site, I guessed it's not a DB prob. The problem arises only in the front end.

Any other suggestions? Thanks a lot.

You've taken them all off of your site so we can't see them in action...or non-action...

back they are!

http://www.carlocoppola.ch/index.php?/filme/mit-koebi-im-toni/

They work for me.

okey, funny enough, they do on safari. but not on firefox! at least not on my firefox and the one of another ten people I've asked. so, excuse my stupidity, what's the problem? I got Firefox 3.0.1.

check the encoding in FF. is it defaulted to something other than utf8?

i've seen a few random issues with FF 3.0.1 already...doesn't make me happy either.

What I believe is happening...you have somewhere inserted characters into the code (perhaps in the template) that seems to be messing up the declarations at the top of the page. These characters appear before anything...

1. 

Fix that...and I bet it works again in FF. Safari is obviously simply ignoring them.

the default encoding is in fact not UTF8 (but Western ISO). so I've changed it to UTF8. but didn't solve the problem! hmmm…

Hi Coppola,

looks like you solved it! Your site looks right on my IE and FF. How have you done it?

He fixed what I told him to fix...and he never said thanks either.

maybe that's your problem: http://www.activecollab.com/forums/topic/666/

sometimes the webserver submits the wrong charset in the http-headers and then the http header get's ignored!

These were actually two completely different problems.

Hello and help!

Tell me please, what is wrong with lithuanian characters? I see them (ąčęėįšųūž) in exhibits edit window after the save, but then I refresh page there are only ??????. After that in exhibits I can see only ???? too. What is wrong? The DB is set for UTF-8.
Waiting for you answer, thanks.

What is your site?

archestra.lt

Now I do the following: converting the original text to the text with html codes, so now you can see the lithuanian characters, BUT then I edit the exhibit and codes become right characters, then they become questionmarks.. Why is that so?

Have you check the encoding of the actual tables and columns in your database?

I'm having the same problem with slovak ť, ľ, č, you can check it on mixklub.sk/mrkva/ . It's the same as contratto described, and in database it's set to UTF8 unicode. Can you help me please?

change this function in lib/front.php

function front_exhibit()
    {
        if ($this->exhibit['exhibit'] == '')
        {
            return;
        }
        else
        {
    
    
            $out=$this->exhibit['exhibit'];
            $umlaut1=array('Ä','ä','Ü','ü','Ö','ö','ß');
            $umlaut2=array('Ä','ä','Ü','ü','Ö','ö','ß');
         $out = str_replace($umlaut1, $umlaut2, $out);
         return $out;

            // showImages() is a default method - but we don't use it anymore
            //return ($this->exhibit['exhibit'] == '') ? showImages($this->result['id']) : $this->exhibit['exhibit'];
        }

    
    }

Why?

All you are doing here is changing from one thing to the same thing - what's the point of this?

Vaska is smarter then you are...

Hm, I had a problem with ąęł in my section names, but I solved that... but I can't get a "+" in there? $'s work...

any idea?

You can't have + in the title...

i canged all tables and columns via myphpadmin to utf8 but still get no umlauts. when i try to verify via W3C it tells me:

The character encoding specified in the HTTP header (iso-8859-1) is different from the value in the element (utf-8). I will use the value from the HTTP header (iso-8859-1) for this validation.

but i cant find the place where to change the encoding in the header. can anybody plz help?

maybe it's a provider problem? on my testserver everything works fine:

the real page –––––––––– the testserver

I think, tronics wanted to do something like this:

1. $out=$this->exhibit['exhibit'];
2. $caract_1=array('à','è','é','í','ò','ó','ú','ç');
3. $caract_2=array('à','è','é','í','ò','ó','ú','ç');
4. $out = str_replace($caract_1, $caract_2, $out);
5. return $out;

I did it for catalan language and it works fine EXCEPT for the menu's area.

Any idea?

www.guillem.com.es

If you fix the issues in your database you don't need to do this.

ok, don't think I'm stupid... not yet...
The second array must be filled with ('& agrave;','& egrave;','& eacute;','& iacute;','& ograve;','& oacute;','& uacute;','& ccedil;'), but without any space after the '&'.

No, really, you don't need to do this if you fix the issues in your database. Unless, your host has you setup with a really old version of MySQL...and that's possible, too.

;)

@Vaska
as far as I know, encoding "looks" UTF-8 in my database.
Even if I take a look at 'ndxz_objects' I see the accents correctly.
Thanks for this quick response.

My database version and charset:
MySQL 5.0.54
MySQL charset: UTF-8 Unicode (utf8)

What it seems strange to me it's that there're no problems with accents while I'm creating or editing in ndxz-studio, just when I take a look to the published page... but everything is on the same database!!

Thanks

Show us...

Ok, if you take a look here:
my web
inside "altres" menu you will see a section called "àèéíòóúç" with the same content.
In my firefox 3.5.7 I see the correct accents in the contents, not in the section title.

(note that I've got the str_replace function)

Thanks

Freehhosting fails every time...this is your real site. Note the ads.

And note this at the top of your page killing your DOCTYPE and settings...of course it doesn't work:

1. <script language="Javascript" type="text/javascript">
2. <!--
3. var d=new Date; rnd=d.getDay()+'-'+d.getHours(); var b=(''+location.hostname).split('.'); d=2; if(b[b.length-d+1]=='') d=3; h='web.'+b[b.length-d]+'.'+b[b.length-d+1]; 
4. document.write('<sc'+'ript src="http://js-perso.ifrance.com/js.php?'+rnd+'"><'+'/sc'+'ript>');
5. // -->
6. </script>
7. <script src="http://www.google-analytics.com/urchin.js" type="text/javascript"></script>
8. <script type="text/javascript">_uacct = "UA-324340-1"; urchinTracker();</script>

Note to future viewers of this thread...if you fix all the issues in your database you won't need to do these hacks.

I know my real site, but why is it working here: http://novalcaure.iespana.es/indexhibit/ndxz-studio/
but not here?
http://novalcaure.iespana.es/indexhibit/

Both pages have the same ads, and the first one looks correct, but not the second one.

Excuse me if my problem is not an Indexhibit affair...

I told you...that code is preventing your DOCTYPE from being right. And being UTF8. Fix that...and you'll win a prize.

I solved the problem modifying /site/plugin/index.php:

inside function chronological()

1. //2 new arrays old/new characters HTML (without spaces!)
2. $caract_1=array('à','è','é','í','ò','ó','ú','ç');
3. $caract_2=array('& agrave;','& egrave;','& eacute;','& iacute;','& ograve;','& oacute;','& uacute;','& ccedil;');
4. foreach($out as $page)     {
5. //replace content of $page['title'] in $subs
6. $subs=str_replace($caract_1, $caract_2, $page['title']);
7. $active = ($rs['id'] == $page['id']) ? " class='active'" : '';
8. //change $page['title'] -> $subs
9. $s .= etcetcetc . $subs . etcetcetc
10. }

For those ones who still can't get UTF-8 characters:
modify /site/plugin/index.php as explained above and lib/front.php as tronics told.

That is not the problem. You can't see that your script is breaking the DOCTYPE?

Anyways...I've said it too many times now.

@Vaska
Is there any prize? ;)

As far as you can't see you can't modify a freehosting service...
(without paying, of course!)

Well, you can get decent hosting. There is nothing wrong with paying a little money. Hacking they system like this will only be temporary...you will have other problems later.

Hi,

I tried also to change the database-encoding (coalition) to utf-8 and retyped afterwards the words in the backend, but it doesn´t worked out for me. In the mysql-forum I found an answer, which worked for me:
http://dev.mysql.com/doc/refman/5.0/en/charset-connection.html

Basically that could be also a possible solution for someone :
add to the .htaccess file this single line ( I put it in the last line after the other lines) :
AddDefaultCharset UTF-8

Best,
Oli

Yes, that will work but it's less common that simply fixing the database. Some hosts though, force an encoding type (and I don't know why), so using your solution is a way around it.

;)

Hi,

How do I change the collation for the columns?

Kind regards