Palizeichen und andere Kleinigkeiten, die nach der utf-8 Konvertierung ersetzbar sind.
Pali-Zeichen:find - replace (nicht verwenden!!) á¹… ṅ
Å« ū
Ä ā
ḷ ḷ
ñ ṇ
á¹ ṭ
ā« ī
ṇ ṇ
ṭ ṭ
ṃ ṃ
Ñ Ñ
ā€ Ā
Ḡḍ
ḍŒ Ḍ
Ṭ Ṭ
– –
‘ ‘
’ ’
… …
Â
<(i>
Was nicht so gut verlaufen ist und nun über SQL im myAdmin-Panel letztlich gemacht wurde:
in der Tabelle: `tp_articles` UPDATE `tp_articles`
SET `body` = replace(body, 'Ä«', 'ī');
UPDATE `tp_articles`
SET `intro` = replace(intro, 'Ä«', 'ī');
UPDATE `tp_articles`
SET `subject` = replace(subject, 'Ä«', 'ī');
UPDATE `tp_articles`
SET `body` = replace(body, 'Ä', 'ā');
UPDATE `tp_articles`
SET `intro` = replace(intro, 'Ä', 'ā');
UPDATE `tp_articles`
SET `subject` = replace(subject, 'Ä', 'ā');
UPDATE `tp_articles`
SET `body` = replace(body, 'ḷ', 'ḷ');
UPDATE `tp_articles`
SET `intro` = replace(intro, 'ḷ', 'ḷ');
UPDATE `tp_articles`
SET `subject` = replace(subject, 'ḷ', 'ḷ');
UPDATE `tp_articles`
SET `body` = replace(body, 'ṃ', 'ṃ');
UPDATE `tp_articles`
SET `intro` = replace(intro, 'ṃ', 'ṃ');
UPDATE `tp_articles`
SET `subject` = replace(subject, 'ṃ', 'ṃ');
UPDATE `tp_articles`
SET `body` = replace(body, '–', '–');
UPDATE `tp_articles`
SET `intro` = replace(intro, '–', '–');
UPDATE `tp_articles`
SET `subject` = replace(subject, '–', '–');
UPDATE `tp_articles`
SET `body` = replace(body, 'á¹…', 'ṅ');
UPDATE `tp_articles`
SET `intro` = replace(intro, 'á¹…', 'ṅ');
UPDATE `tp_articles`
SET `subject` = replace(subject, 'á¹…', 'ṅ');
UPDATE `tp_articles`
SET `body` = replace(body, 'á¹', 'ṭ');
UPDATE `tp_articles`
SET `intro` = replace(intro, 'á¹', 'ṭ');
UPDATE `tp_articles`
SET `subject` = replace(subject, 'á¹', 'ṭ');
UPDATE `tp_articles`
SET `body` = replace(body, 'ñ', 'ñ');
UPDATE `tp_articles`
SET `intro` = replace(intro, 'ñ', 'ñ');
UPDATE `tp_articles`
SET `subject` = replace(subject, 'ñ', 'ñ');
UPDATE `tp_articles`
SET `body` = replace(body, 'ṭ‡', 'ṇ');
UPDATE `tp_articles`
SET `intro` = replace(intro, 'ṭ‡', 'ṇ');
UPDATE `tp_articles`
SET `subject` = replace(subject, 'ṭ‡', 'ṇ');
UPDATE `tp_articles`
SET `body` = replace(body, 'á¸', 'ḍ');
UPDATE `tp_articles`
SET `intro` = replace(intro, 'á¸', 'ḍ');
UPDATE `tp_articles`
SET `subject` = replace(subject, 'á¸', 'ḍ');
UPDATE `tp_articles`
SET `body` = replace(body, 'Å«', 'ū');
UPDATE `tp_articles`
SET `intro` = replace(intro, 'Å«', 'ū');
UPDATE `tp_articles`
SET `subject` = replace(subject, 'Å«', 'ū');
UPDATE `tp_articles`
SET `body` = replace(body, '‘', '‘');
UPDATE `tp_articles`
SET `intro` = replace(intro, '‘', '‘');
UPDATE `tp_articles`
SET `subject` = replace(subject, '‘', '‘');
UPDATE `tp_articles`
SET `body` = replace(body, '’', '’');
UPDATE `tp_articles`
SET `intro` = replace(intro, '’', '’');
UPDATE `tp_articles`
SET `subject` = replace(subject, '’', '’');
UPDATE `tp_articles`
SET `body` = replace(body, '…', '…');
UPDATE `tp_articles`
SET `intro` = replace(intro, '…', '…');
UPDATE `tp_articles`
SET `subject` = replace(subject, '…', '…');
UPDATE `tp_articles`
SET `body` = replace(body, 'Ä€', 'Ā');
UPDATE `tp_articles`
SET `intro` = replace(intro, 'Ä€', 'Ā');
UPDATE `tp_articles`
SET `subject` = replace(subject, 'Ä€', 'Ā');
UPDATE `tp_articles`
SET `body` = replace(body, 'Ū', 'Ū');
UPDATE `tp_articles`
SET `intro` = replace(intro, 'Ū', 'Ū');
UPDATE `tp_articles`
SET `subject` = replace(subject, 'Ū', 'Ū');
UPDATE `tp_articles`
SET `body` = replace(body, 'ā', 'ā');
UPDATE `tp_articles`
SET `intro` = replace(intro, 'ā', 'ā');
UPDATE `tp_articles`
SET `subject` = replace(subject, 'ā', 'ā');
UPDATE `tp_articles`
SET `body` = replace(body, 'ṭ¬', 'Ṭ');
UPDATE `tp_articles`
SET `intro` = replace(intro, 'ṭ¬', 'Ṭ');
UPDATE `tp_articles`
SET `subject` = replace(subject, 'ṭ¬', 'Ṭ');
Sonstige Anpassungen in `tp_articles`:
für den richtig Pfad zum css file: UPDATE `tp_articles`
SET `body` = replace(body, '<link rel="stylesheet" type="text/css" href="tipitaka', '<link rel="stylesheet" type="text/css" href="http://forum.sangham.net/tipitaka');
UPDATE `tp_articles`
SET `intro` = replace(intro, '<link rel="stylesheet" type="text/css" href="tipitaka', '<link rel="stylesheet" type="text/css" href="http://forum.sangham.net/tipitaka');
Pali-Zeichen für `tp_dlmanager` UPDATE `tp_dlmanager`
SET `name` = replace(name, 'Ä«', 'ī');
UPDATE `tp_dlmanager`
SET `description` = replace(description, 'Ä«', 'ī');
UPDATE `tp_dlmanager`
SET `name` = replace(name, 'Ä', 'ā');
UPDATE `tp_dlmanager`
SET `description` = replace(description, 'Ä', 'ā');
UPDATE `tp_dlmanager`
SET `name` = replace(name, 'ḷ', 'ḷ');
UPDATE `tp_dlmanager`
SET `description` = replace(description, 'ḷ', 'ḷ');
UPDATE `tp_dlmanager`
SET `name` = replace(name, 'ṃ', 'ṃ');
UPDATE `tp_dlmanager`
SET `description` = replace(description, 'ṃ', 'ṃ');
UPDATE `tp_dlmanager`
SET `name` = replace(name, '–', '–');
UPDATE `tp_dlmanager`
SET `description` = replace(description, '–', '–');
UPDATE `tp_dlmanager`
SET `name` = replace(name, 'á¹…', 'ṅ');
UPDATE `tp_dlmanager`
SET `description` = replace(description, 'á¹…', 'ṅ');
UPDATE `tp_dlmanager`
SET `name` = replace(name, 'á¹', 'ṭ');
UPDATE `tp_dlmanager`
SET `description` = replace(description, 'á¹', 'ṭ');
UPDATE `tp_dlmanager`
SET `name` = replace(name, 'ñ', 'ñ');
UPDATE `tp_dlmanager`
SET `description` = replace(description, 'ñ', 'ñ');
UPDATE `tp_dlmanager`
SET `name` = replace(name, 'ṭ‡', 'ṇ');
UPDATE `tp_dlmanager`
SET `description` = replace(description, 'ṭ‡', 'ṇ');
UPDATE `tp_dlmanager`
SET `name` = replace(name, 'á¸', 'ḍ');
UPDATE `tp_dlmanager`
SET `description` = replace(description, 'á¸', 'ḍ');
UPDATE `tp_dlmanager`
SET `name` = replace(name, 'Å«', 'ū');
UPDATE `tp_dlmanager`
SET `description` = replace(description, 'Å«', 'ū');
UPDATE `tp_dlmanager`
SET `name` = replace(name, '‘', '‘');
UPDATE `tp_dlmanager`
SET `description` = replace(description, '‘', '‘');
UPDATE `tp_dlmanager`
SET `name` = replace(name, '’', '’');
UPDATE `tp_dlmanager`
SET `description` = replace(description, '’', '’');
UPDATE `tp_dlmanager`
SET `name` = replace(name, '…', '…');
UPDATE `tp_dlmanager`
SET `description` = replace(description, '…', '…');
UPDATE `tp_dlmanager`
SET `name` = replace(name, 'Ä€', 'Ā');
UPDATE `tp_dlmanager`
SET `description` = replace(description, 'Ä€', 'Ā');
UPDATE `tp_dlmanager`
SET `name` = replace(name, 'Ū', 'Ū');
UPDATE `tp_dlmanager`
SET `description` = replace(description, 'Ū', 'Ū');
UPDATE `tp_dlmanager`
SET `name` = replace(name, 'ā', 'ā');
UPDATE `tp_dlmanager`
SET `description` = replace(description, 'ā', 'ā');
Für Pali in `tp_variables` (tag-Wolke im Forum und Linkbaum im TP) UPDATE `tp_variables`
SET `value1` = replace(value1, 'Ä«', 'ī');
UPDATE `tp_variables`
SET `value2` = replace(value2, 'Ä«', 'ī');
UPDATE `tp_variables`
SET `value1` = replace(value1, 'Ä', 'ā');
UPDATE `tp_variables`
SET `value2` = replace(value2, 'Ä', 'ā');
UPDATE `tp_variables`
SET `value1` = replace(value1, 'ḷ', 'ḷ');
UPDATE `tp_variables`
SET `value2` = replace(value2, 'ḷ', 'ḷ');
UPDATE `tp_variables`
SET `value1` = replace(value1, 'ṃ', 'ṃ');
UPDATE `tp_variables`
SET `value2` = replace(value2, 'ṃ', 'ṃ');
UPDATE `tp_variables`
SET `value1` = replace(value1, '–', '–');
UPDATE `tp_variables`
SET `value2` = replace(value2, '–', '–');
UPDATE `tp_variables`
SET `value1` = replace(value1, 'á¹…', 'ṅ');
UPDATE `tp_variables`
SET `value2` = replace(value2, 'á¹…', 'ṅ');
UPDATE `tp_variables`
SET `value1` = replace(value1, 'á¹', 'ṭ');
UPDATE `tp_variables`
SET `value2` = replace(value2, 'á¹', 'ṭ');
UPDATE `tp_variables`
SET `value1` = replace(value1, 'ñ', 'ñ');
UPDATE `tp_variables`
SET `value2` = replace(value2, 'ñ', 'ñ');
UPDATE `tp_variables`
SET `value1` = replace(value1, 'ṭ‡', 'ṇ');
UPDATE `tp_variables`
SET `value2` = replace(value2, 'ṭ‡', 'ṇ');
UPDATE `tp_variables`
SET `value1` = replace(value1, 'á¸', 'ḍ');
UPDATE `tp_variables`
SET `value2` = replace(value2, 'á¸', 'ḍ');
UPDATE `tp_variables`
SET `value1` = replace(value1, 'Å«', 'ū');
UPDATE `tp_variables`
SET `value2` = replace(value2, 'Å«', 'ū');
UPDATE `tp_variables`
SET `value1` = replace(value1, '‘', '‘');
UPDATE `tp_variables`
SET `value2` = replace(value2, '‘', '‘');
UPDATE `tp_variables`
SET `value1` = replace(value1, '’', '’');
UPDATE `tp_variables`
SET `value2` = replace(value2, '’', '’');
UPDATE `tp_variables`
SET `value1` = replace(value1, '…', '…');
UPDATE `tp_variables`
SET `value2` = replace(value2, '…', '…');
UPDATE `tp_variables`
SET `value1` = replace(value1, 'Ä€', 'Ā');
UPDATE `tp_variables`
SET `value2` = replace(value2, 'Ä€', 'Ā');
UPDATE `tp_variables`
SET `value1` = replace(value1, 'Ū', 'Ū');
UPDATE `tp_variables`
SET `value2` = replace(value2, 'Ū', 'Ū');
UPDATE `tp_variables`
SET `value1` = replace(value1, 'ā', 'ā');
UPDATE `tp_variables`
SET `value2` = replace(value2, 'ā', 'ā');
UPDATE `tp_variables`
SET `value1` = replace(value1, 'ṭ¬', 'Ṭ');
UPDATE `tp_variables`
SET `value2` = replace(value2, 'ṭ¬', 'Ṭ');
Damit sollte die Pali-Zeichenverwirrung wieder in Ordnung gebracht sein. Wenn etwas vergessen würde im jederzeit im selben Stil nachholbar. Und nun zu den Sonderzeichen im Deutschen und anderen...