Author Topic: Use SET NAMES to enable correct Character Set handling  (Read 2177 times)

Offline thorn

  • Posts: 980
  • Gender: Male
    • Projects
Use SET NAMES to enable correct Character Set handling
« 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:  et" class="bbc_link" target="_blank">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

Offline thorn

  • Posts: 980
  • Gender: Male
    • Projects
Re: Use SET NAMES to enable correct Character Set handling
« Reply #1 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.