Charecter sets

[ku]

Hello,
First question -
the default character set of our mysql server is:
character set database utf8 utf8

It works 'nearly' without problems but -
if Czech letter is used it Title then the page is accesible only in Firefox. In IE6 title is complet garbage. Also there is a problem in export to pdf, some letters are shown badly.

What is the best way to use international letters ?
We would like to keep database as utf8, is it possible to
simply patch includes/Database.php , put there the line:
mysql_query("SET NAMES 'latin2'");
and put into .htaccess the line:
AddDefaultCharset iso-8859-2

Or is there different way ?

Second question - is innodb supported ? When I tried it there were problems that transactions in the Dkiwiki's code were not properly closed and nothing was written into database. After switch to MyIsam it works.

Third question - is database table CategoryLinks used in a code ? Because we have utf-8 database I had to switch fields cl_to and cl_sortkey to latin2 otherwise dekiwiki cannot be instaled.

Thanks, Ivan

[imported_RoyK]

Hey Ivan,

If you look under includes/DefaultSettings.php, you might also want to change these values: $wgInputEncoding, $wgOutputEncoding, $wgUseLatin to use UTF-8.


If you want to maintain international characters, I would suggest getting everything into UTF-8 and not using ISO-8859-2. This will maintain future forward compatibility.

InnoDB is not fully supported; I would stick with ISAM to maintain the full featureset.


- Roy

[Bizzz]

I'm afraid I have not understood all of your explanation.
Are you sure it's mandatory to modify the 3 values into includes/DefaultSettings.php?
When looking at its content, I can read the following comment :
# LanguageUtf8.php normally overrides this
# unless you set the next option to true
Can you detail all the needed modifications to do when you say "I would suggest getting everything into UTF-8"

And when you say "InnoDB is not fully supported", what are the modifications to do for having a correct (ISAM?) DB (without lost of existing data)?

If I made all of these modifications, could you confirm I can use accentuated characters into titles, without actual displaying problems?