Non-latin Characters

eiaa / 2007-10-25 07:56:34   

I have tested Russian and Japanese character support on the Testdrive site with no problem. If I try this on a new installed version it doesn't work. The non-latin characters which I entered become ????? after I hit the safe button. I have seen other sites in non-latin languages - anyone know the secret what I would have to adjust. Any hint is warmly appreciated. Thanks for your time.

Vaska A / 2007-10-25 09:33:50   

It does work...the problem is that on some servers they sort of force the characters down to latin1 only (in the database). You can go into your database and reset everything...yes, it's a pain...

Using PHPMyAdmin you can set the collation to utf-general-ci and then it will be good. Nearly all hosts provide this tool for you.

In the next version of Indexhibit we're going to try to come up with a way to prevent this from happening...but it might not be possible.

eiaa / 2007-10-25 14:07:20   

Vaska,Thank you very much for your prompt reply. I have tried what you have suggested and came to this point. It does not work yet.What I did is - I changed the collation in the following titles to "utf8_general_ci" inside the database.

iptocountryndxz_mediandxz_objectsndxz_objects_prefsndxz_sectionsndxz_settingsndxz_statndxz_users

There are still subcategories inside these top categories - for example inside "ndxz media" is:media_idmedia_ref_idmedia_obj_typelatin 1_swedish_cimedia_mimelatin1_swedish_cimedia_tagslatin1_swedish_cimedia_file latin1_swedish_cimedia_titlelatin1_swedish_cimedia_captionlatin1_swedish_cimedia_xvarchar(5) latin1_swedish_cimedia_yvarchar(5) latin1_swedish_cimedia_kbmedia_udatemedia_uploadedmedia_ordermedia_hide

In these subcategories I seem to be unable to make a change - it does not stick. Do these subcategories also have to be "utf8_general_ci"? I have no idea how come there is swedish in there - strange thing na, the host is media temple - pretty far away. Shall I contact media temple or do you have a other suggestion.Thank you very muchCheers

Vaska A / 2007-10-25 15:56:14   

You have to change it for...

The tables individually AND the columns. Both.

Vaska A / 2007-10-25 16:09:05   

If you send me the login info to get to your database I will take a look...you can find a contact email on the Contribute page.

beaplanb / 2010-07-13 17:04:29   

hello,
i don't know if it is of any help right now, but i had the same problem and managed to solve it changing the xml:lang + lang to the language my page was meant to be read...

Vaska A / 2010-07-13 17:08:11   

No, that is not the real solution. There are many threads around here with the correct way to solve things (like above).

I'm only posting this because I don't want people following the wrong path.

This thread has been closed, thank you.