No more Questions!
ZMS 2 UTF-8 / LOG
1. Files umkodieren
Files mit UTF-Codierung (mit oder ohne BOM) löschen:
- htdocs/code/inc/external/tcpdf/barcodes.php
- htdocs/code/inc/external/tcpdf/pdf417.php
- htdocs/code/inc/external/tcpdf/tcpdf.php
- htdocs/code/inc/external/tcpdf/doc/com-tecnick-tcpdf/PDF417.html
- htdocs/code/inc/external/tcpdf/doc/com-tecnick-tcpdf/TCPDF.html
- htdocs/code/inc/external/tcpdf/doc/com-tecnick-tcpdf/TCPDFBarcode.html
- htdocs/javascript/admin/lib/ckeditor/*.js
- htdocs/javascript/admin/lib/jquery/*
- htdocs/javascript/admin/lib/jquery-ui-1.8.10.custom/js/jquery.ui.datepicker-de.js
Netbeans Replace Einstellungen:
- File Name Patterns: *.php,*.css,*.js,*.txt,*.html
- Scope: Open Project
- Options: Match Case
Ersetzungen:
- htdocs/code/inc/util/util_string.class.php von Hand ersetzt!
- Sonderzeichen: © « µ »
- Buchstaben: Ä Ö Ü ä é ö ü
2. HTML Header in pagestyles korrekt (UTF-8)
Betroffene Files:
- htdocs/code/pagestyles/admin/admin.php
- htdocs/code/pagestyles/standard.php
- htdocs/code/pagestyles/standard_preview.php
3. UTIL_FILTER::HTMLEnt()
Folgende Methoden von campain.caritas.ch übernommen:
- UTIL_FILTER::HTMLEnt()
- UTIL_FILTER::UTF8toHTML()
4. DB-Init
- In htdocs/code/inc/db.class.php in die Methode OpenConnection() eingebaut:
$this->Query('set names 'utf8'');
5. Datenbank Backup
- db/20110923_zeitgei_zms.sql.zip
6. Datenbank auf UTF-8 umstellen
Queries:
- ALTER DATABASE `zeitgei_zms` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
- ALTER TABLE `arrangements` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
- ALTER TABLE `arrangements` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
- ALTER TABLE `featuremedias` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
- ALTER TABLE `featuremedias` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
- ALTER TABLE `featurerequiredmedias` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
- ALTER TABLE `featurerequiredmedias` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
- ALTER TABLE `featurerequiredwords` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
- ALTER TABLE `featurerequiredwords` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
- ALTER TABLE `features` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
- ALTER TABLE `features` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
- ALTER TABLE `featurestylecomponents` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
- ALTER TABLE `featurestylecomponents` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
- ALTER TABLE `featurestyleincludes` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
- ALTER TABLE `featurestyleincludes` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
- ALTER TABLE `featurestyles` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
- ALTER TABLE `featurestyles` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
- ALTER TABLE `featurewords` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
- ALTER TABLE `featurewords` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
- ALTER TABLE `options` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
- ALTER TABLE `options` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
- ALTER TABLE `pagefeatureassign` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
- ALTER TABLE `pagefeatureassign` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
- ALTER TABLE `pages` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
- ALTER TABLE `pages` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
- ALTER TABLE `pagestyles` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
- ALTER TABLE `pagestyles` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
- ALTER TABLE `pagevariables` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
- ALTER TABLE `pagevariables` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
- ALTER TABLE `users` CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
- ALTER TABLE `users` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
Indexes:
- Manuell droppen und neu erstellen
7. Check
- Database:
- Umlaute korrekt gespeichert: ok
- Frontend:
- Browser switcht auf UTF-8: ok
- Umlaute korrekt: ok
- Backend:
- Browser switcht auf UTF-8: ok
- Umlaute korrekt: ok
- CK Editor: ok
- Diverses:
- UTIL_Mail::SendMail: ok