Use SET NAMES to enable correct Character Set handling

[thorn]

Hallo,

just want to say that there was some significant additions to the mentioned pages, recently.

thorn.

[thorn]

Hello,

there were several postings about usage of the SQL-Statement "SET NAMES" in class.database.php in the last few years. All of them wrote how to add SET NAMES to the framework, but no one offered a solution on how to upgrade from an non-SET-NAMES installation to an SET-NAMES-aware one (that is: how to convert the database, if necessary).

Over the last days I tried to figure out a possible solution for this issue. Please read more here about:
- how to add SET NAMES to WB install-files.
- how to add SET NAMES to an existing WB site.
- how to convert the database, if necessary.
http://nettest.thekk.de/doku.php/misc:tips:start and especially here:  http://nettest.thekk.de/doku.php/misc:tips:convert_mysql_charset


thorn.

PS:
I have added a feature-request for this issue: http://project.websitebaker2.org/ticket/804