Language in categories

Geiri · March 28th, 2009, 10:27 PM

I have run into a small problem.

My Icelandic letters do not show right but only in the categories and in admin?

Everthing is allright in vbulletin and on other pages.

I have marked the error in red and the lang strings that are ok in green.

Strange error??

Chuck S · March 28th, 2009, 11:04 PM

please post what is the correct display of the wrong say catname so I can test on my site.

Geiri · March 29th, 2009, 08:09 AM

Notenda gallerí

Garðurinn

and words like: aðgangsorð, það, öðruvísi

Chuck S · March 29th, 2009, 04:50 PM

Omegatron Classifieds - Main Index

I would suspect your tables are not UTF8 in the database. Really to support characters like that your tables need to be utf8 not latin encoding.

Try redownloading the build and run just upgrade.php not phrases.php

There are some queries in there to change the tables to utf8

I did extensive testing with your icenlandic russian arabic korean chinese etc and all work fine but of course my tables are utf8. My character encoding on my pages is also utf8

Geiri · March 29th, 2009, 05:43 PM

Just to prevent some missunderstanding this error is in Photopost

I say this becouse you post a link to classifieds. But maby they are the same

I am downloading Pp code now. :-)

Chuck S · March 29th, 2009, 05:45 PM

Ah I dont know about Photopost all my reworks with languages is with classifieds and reviewpost.

Geiri · March 29th, 2009, 06:49 PM

MySQL charset: UTF-8 Unicode (utf8)
MySQL connection collation: utf8_general_ci

Tables are in collation: latin1_swedish_ci (And I know that is not the problem)

I have changed the tables to utf8_bin, utf8_general etc... and experimented with this in all ways I have edited the categorie names in mysql and they show right there and they show right in Pp admin after that but they do not show right on the page.

Screenshot shows text after editing in mysql and it show right in admin
you allso see all the nonsens that is printed.

Chuck S · March 29th, 2009, 08:37 PM

Geiri

well look in adm-cats.php you will see lines like this

Code:

Content visible to verified customers only.

maybe try this

Code:

Content visible to verified customers only.

Geiri · March 29th, 2009, 09:25 PM

No it wont work.

If I turn my vbulletin HTML Character Set to utf-8 that text shows right but everthing else in photopost and in vbulletin becomes unreadable.
See screenshot.

The categories and admin are the only place in photopost who are effected by this.

Chuck S · March 29th, 2009, 09:28 PM

Correct why not do just what I said in my last post make an edit to adm-cats.php search for the htmlentities line on line 463 replace it with what I wrote and reedit the catname

Geiri · March 29th, 2009, 09:50 PM

Allready tried that it is not working

Chuck S · March 30th, 2009, 09:23 AM

You can send info through the contact us link in the header.

Geiri · March 30th, 2009, 06:39 PM

Quote:

Originally Posted by Chuck S

You can send info through the contact us link in the header.

I am not following you here

maby you got the wrong topic?

Get some sleep

Chuck S · March 30th, 2009, 10:06 PM

what I posted should work. I said if it did not you should send us server info to look at it. Photopost Pro does not claim to support icelandic so this is really above and beyond support but I dont have any issues helping out

Geiri · March 30th, 2009, 11:36 PM

This is my MYSQL info.

MySQL charset: UTF-8 Unicode (utf8)
MySQL connection collation: latin1_swedish_ci
Tables are in collation: latin1_swedish_ci (And I know that is not the problem)

What server info do you want phpinfo, Headder info?

I can fix this by using code from this page. ISO-8859-1
ISO 8859-1 (Latin-1) Characters List

Chuck S · March 31st, 2009, 03:53 AM

Correct your tables need to be in utf8 not latin swedish this is the heart of the issue

I need phpmyadmin info to see database and ftp info

Geiri · April 10th, 2009, 10:58 AM

I am still having this trouble and I can not resolve this my self.
If you can take a look I would aprisiate it

You got mail.

Chuck S · April 10th, 2009, 11:10 AM

Geiri if this is photopost that product makes no such claims to support icelandic

Geiri · April 10th, 2009, 01:55 PM

Quote:

Originally Posted by Chuck S

Geiri if this is photopost that product makes no such claims to support icelandic

That is true but, Photopost claims it suports Multi-language

Other Features
Multi-language support via template files. Packaged with English, German, French, Swedish, Dutch languages

And the thing is I have the exact same setup runing at my own site with out this bug.

Icelandic has mostly the same letters as swedish and in fact I am using latin1_swedish_ci for my db collation So if I would write the categori name in swedish I would get the same error

So I tried the German word Österreich it shows like Ã–sterreich
The swedish words
Sök shows like SÃ¶k
Miljö och annat shows like MiljÃ¶ och annat
Läs mer... shows like LÃ¤s mer...

This are languages that Photopost claims it suports and are not showning right.

You can take a look at it here. Forsíða - Sprotinn.is - GallerÃ

This bug is inside admin panel and in categories.
I have no problem with vbulletin categories or admin panel.

Chuck S · April 10th, 2009, 05:22 PM

Here is what I know

Language in categories

Your encoding must be set using that.

You must also properly load in both admin-inc.php file and the language file the encoding to UTF-8

You can also use the setnames to UTF-8

Your tables need to be UTF-8