ipb2_utf8_convert_v1.0.php > Invisionize.eu - IP.Board (IPB) News
Kanał Rss Kanał Rss
Kanał Atom Kanał Atom

ipb2_utf8_convert_v1.0.php

wersja drukowalna wersja Microsoft Word wersja HTML

Experimental PHP script to convert the content of an IPB 2.3 database to utf8

INSTALLATION: put in IPB home folder, check/modify the configuration parameters and run it from command line - the script may require several hours to complete.

- Fully automatic - it will examine your database and convert only "char varchar text enum set tinytext mediumtext longtext" fields.
- Fields with other (known) encodings can be specified.
- Fields to be ignored can be specified.
- Lengths in fields that are serialized are properly corrected after the conversion.

If you get "MySQL Server has gone away" message", try setting the MySQL server variable "max_allowed_packet" to a high value (e.g. 24M), or decrease the value of the $limit configuration parameter.

NOTES:
1. USE AT YOUR OWN RISK
2. ALWAYS KEEP A BACKUP COPY OF THE ORIGINAL DATABASE
3. CONVERSION TO UTF-8 IS IRREVERSIBLE

pon, 20 kwiecień 2009