WebsiteBaker Community Forum

General Community => Global WebsiteBaker 2.8.x discussion => Topic started by: thorn on September 20, 2009, 05:10:35 PM

Title: Use SET NAMES to enable correct Character Set handling
Post by: thorn on September 20, 2009, 05:10:35 PM
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_chars et


thorn.

PS:
I have added a feature-request for this issue: http://project.websitebaker2.org/ticket/804
Title: Re: Use SET NAMES to enable correct Character Set handling
Post by: thorn on October 17, 2009, 06:03:00 PM
Hallo,

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

thorn.