http://www.gevitas.de/wiki/index.php?action=history&feed=atom&title=Hinweise_zu_mySQL_collation Hinweise zu mySQL collation - Versionsgeschichte 2026-05-24T11:38:35Z Versionsgeschichte dieser Seite in GEVITAS MediaWiki 1.29.1 http://www.gevitas.de/wiki/index.php?title=Hinweise_zu_mySQL_collation&diff=16467&oldid=prev Gevitas am 10. März 2023 um 12:14 Uhr 2023-03-10T12:14:05Z <p></p> <table class="diff diff-contentalign-left" data-mw="interface"> <col class='diff-marker' /> <col class='diff-content' /> <col class='diff-marker' /> <col class='diff-content' /> <tr style='vertical-align: top;' lang='de'> <td colspan='2' style="background-color: white; color:black; text-align: center;">← Nächstältere Version</td> <td colspan='2' style="background-color: white; color:black; text-align: center;">Version vom 10. März 2023, 12:14 Uhr</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l26" >Zeile 26:</td> <td colspan="2" class="diff-lineno">Zeile 26:</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>:ALTER TABLE `maufpo_version` CONVERT TO CHARACTER SET latin1 COLLATE latin1_german1_ci ;</div></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>:ALTER TABLE `maufpo_version` CONVERT TO CHARACTER SET latin1 COLLATE latin1_german1_ci ;</div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;"></ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">;Das kann man auch im REFLEX-Checker (ab Vers. 4.12.23.0310) machen:</ins></div></td></tr> <tr><td colspan="2">&#160;</td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins style="font-weight: bold; text-decoration: none;">:Im SQL-Editor rechte Maustaste auf die Tabelle und auswählen mySQL &amp;rArr; Collation auf &quot; latin1_german1_ci&quot; setzen</ins></div></td></tr> </table> Gevitas http://www.gevitas.de/wiki/index.php?title=Hinweise_zu_mySQL_collation&diff=16466&oldid=prev Gevitas am 10. März 2023 um 11:50 Uhr 2023-03-10T11:50:16Z <p></p> <table class="diff diff-contentalign-left" data-mw="interface"> <col class='diff-marker' /> <col class='diff-content' /> <col class='diff-marker' /> <col class='diff-content' /> <tr style='vertical-align: top;' lang='de'> <td colspan='2' style="background-color: white; color:black; text-align: center;">← Nächstältere Version</td> <td colspan='2' style="background-color: white; color:black; text-align: center;">Version vom 10. März 2023, 11:50 Uhr</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l15" >Zeile 15:</td> <td colspan="2" class="diff-lineno">Zeile 15:</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>;Setzt den Standard für eine Datenbank:</div></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>;Setzt den Standard für eine Datenbank:</div></td></tr> <tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>:ALTER DATABASE <del class="diffchange diffchange-inline">mediarent </del>CHARACTER SET latin1 COLLATE latin1_german1_ci;</div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>:ALTER DATABASE <ins class="diffchange diffchange-inline">reflex </ins>CHARACTER SET latin1 COLLATE latin1_german1_ci;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>'''Standard''' heisst aber nur, dass '''neue''' Felder bzw. Tabellen diese Collation bekommen, die '''bestehenden''' Felder/Tabellen werden '''nicht''' geändert!</div></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>'''Standard''' heisst aber nur, dass '''neue''' Felder bzw. Tabellen diese Collation bekommen, die '''bestehenden''' Felder/Tabellen werden '''nicht''' geändert!</div></td></tr> <tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l21" >Zeile 21:</td> <td colspan="2" class="diff-lineno">Zeile 21:</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>;Zum Ändern muss das hier verwendet werden:</div></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>;Zum Ändern muss das hier verwendet werden:</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr> <tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>:ALTER TABLE <del class="diffchange diffchange-inline">`reflex`.</del>`maufko_version` CONVERT TO CHARACTER SET latin1 COLLATE latin1_german1_ci ;</div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>:ALTER TABLE `maufko_version` CONVERT TO CHARACTER SET latin1 COLLATE latin1_german1_ci ;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr> <tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>:ALTER TABLE <del class="diffchange diffchange-inline">`reflex`.</del>`mauffu_version` CONVERT TO CHARACTER SET latin1 COLLATE latin1_german1_ci ;</div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>:ALTER TABLE `mauffu_version` CONVERT TO CHARACTER SET latin1 COLLATE latin1_german1_ci ;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr> <tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>:ALTER TABLE <del class="diffchange diffchange-inline">`reflex`.</del>`maufpo_version` CONVERT TO CHARACTER SET latin1 COLLATE latin1_german1_ci ;</div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div>:ALTER TABLE `maufpo_version` CONVERT TO CHARACTER SET latin1 COLLATE latin1_german1_ci ;</div></td></tr> </table> Gevitas http://www.gevitas.de/wiki/index.php?title=Hinweise_zu_mySQL_collation&diff=16465&oldid=prev Gevitas am 10. März 2023 um 11:49 Uhr 2023-03-10T11:49:12Z <p></p> <table class="diff diff-contentalign-left" data-mw="interface"> <col class='diff-marker' /> <col class='diff-content' /> <col class='diff-marker' /> <col class='diff-content' /> <tr style='vertical-align: top;' lang='de'> <td colspan='2' style="background-color: white; color:black; text-align: center;">← Nächstältere Version</td> <td colspan='2' style="background-color: white; color:black; text-align: center;">Version vom 10. März 2023, 11:49 Uhr</td> </tr><tr><td colspan="2" class="diff-lineno" id="mw-diff-left-l17" >Zeile 17:</td> <td colspan="2" class="diff-lineno">Zeile 17:</td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>:ALTER DATABASE mediarent CHARACTER SET latin1 COLLATE latin1_german1_ci;</div></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>:ALTER DATABASE mediarent CHARACTER SET latin1 COLLATE latin1_german1_ci;</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr> <tr><td class='diff-marker'>−</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #ffe49c; vertical-align: top; white-space: pre-wrap;"><div>Standard heisst aber nur, dass neue Felder bzw. Tabellen diese Collation bekommen, die <del class="diffchange diffchange-inline">bestehende </del>Felder/Tabellen werden nicht geändert!</div></td><td class='diff-marker'>+</td><td style="color:black; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #a3d3ff; vertical-align: top; white-space: pre-wrap;"><div><ins class="diffchange diffchange-inline">'''</ins>Standard<ins class="diffchange diffchange-inline">''' </ins>heisst aber nur, dass <ins class="diffchange diffchange-inline">'''</ins>neue<ins class="diffchange diffchange-inline">''' </ins>Felder bzw. Tabellen diese Collation bekommen, die <ins class="diffchange diffchange-inline">'''bestehenden''' </ins>Felder/Tabellen werden <ins class="diffchange diffchange-inline">'''</ins>nicht<ins class="diffchange diffchange-inline">''' </ins>geändert!</div></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"></td></tr> <tr><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>;Zum Ändern muss das hier verwendet werden:</div></td><td class='diff-marker'>&#160;</td><td style="background-color: #f9f9f9; color: #333333; font-size: 88%; border-style: solid; border-width: 1px 1px 1px 4px; border-radius: 0.33em; border-color: #e6e6e6; vertical-align: top; white-space: pre-wrap;"><div>;Zum Ändern muss das hier verwendet werden:</div></td></tr> </table> Gevitas http://www.gevitas.de/wiki/index.php?title=Hinweise_zu_mySQL_collation&diff=16464&oldid=prev Gevitas: Die Seite wurde neu angelegt: „== Worum es geht == Beim Ausführen eines Programmteils unter mySQL kommt es zu dieser Fehlermeldung: Illegal mix of collations (latin1_german1_ci, IMPLIC…“ 2023-03-10T11:48:23Z <p>Die Seite wurde neu angelegt: „== Worum es geht == Beim Ausführen eines Programmteils unter mySQL kommt es zu dieser Fehlermeldung: Illegal mix of collations (latin1_german1_ci, IMPLIC…“</p> <p><b>Neue Seite</b></p><div>== Worum es geht ==<br /> <br /> Beim Ausführen eines Programmteils unter mySQL kommt es zu dieser Fehlermeldung:<br /> <br /> <br /> Illegal mix of collations (latin1_german1_ci, IMPLICIT) and (latin1_swedish_ci, IMPLICIT) for operation '&lt;&gt;'<br /> <br /> Hier verwendet MySQL für die Datenbank als Standard die Collation (Zeichensatz) „latin1_swedish_ci“, der Standard bei einigen mySQL-Versionen.<br /> Als Folge nimmt die Datenbank für neue String-Felder immer als Standard die Collation „latin1_swedish_ci“!<br /> <br /> == Ändern der collation ==<br /> <br /> ;Setzt den Standard für eine Tabelle:<br /> :ALTER TABLE `maufko_version` COLLATE = latin1_german1_ci ;<br /> <br /> ;Setzt den Standard für eine Datenbank:<br /> :ALTER DATABASE mediarent CHARACTER SET latin1 COLLATE latin1_german1_ci;<br /> <br /> Standard heisst aber nur, dass neue Felder bzw. Tabellen diese Collation bekommen, die bestehende Felder/Tabellen werden nicht geändert!<br /> <br /> ;Zum Ändern muss das hier verwendet werden:<br /> <br /> :ALTER TABLE `reflex`.`maufko_version` CONVERT TO CHARACTER SET latin1 COLLATE latin1_german1_ci ;<br /> <br /> :ALTER TABLE `reflex`.`mauffu_version` CONVERT TO CHARACTER SET latin1 COLLATE latin1_german1_ci ;<br /> <br /> :ALTER TABLE `reflex`.`maufpo_version` CONVERT TO CHARACTER SET latin1 COLLATE latin1_german1_ci ;</div> Gevitas