Typo3 - Wechsel von Latin1 auf UTF-8 - MySQL und TYPO3 auf UTF-8 umstellen: Unterschied zwischen den Versionen

Aus Carl-Christian Sautter - Wiki
Zur Navigation springen Zur Suche springen
Zeile 1: Zeile 1:
Fehler:
+
Error:
 
  102: These fields are not properly updated in database: (bodytext) Probably value mismatch with fieldtype.
 
  102: These fields are not properly updated in database: (bodytext) Probably value mismatch with fieldtype.
Lösung:
+
Solution:
 
[http://t3n.de/magazin/mysql-typo3-utf-8-umstellen-tipps-wechsel-latin1-utf-8-220945/3/ http://t3n.de/magazin/mysql-typo3-utf-8-umstellen-tipps-wechsel-latin1-utf-8-220945/3/]
 
[http://t3n.de/magazin/mysql-typo3-utf-8-umstellen-tipps-wechsel-latin1-utf-8-220945/3/ http://t3n.de/magazin/mysql-typo3-utf-8-umstellen-tipps-wechsel-latin1-utf-8-220945/3/]
 +
==Zusammenfassung==
 +
* Check MySQL Default Encoding
 +
<pre>
 +
# mysql
 +
SHOW VARIABLES LIKE 'character_set%';
 +
SHOW VARIABLES LIKE 'collation%';
 +
</pre>
 +
* Set MySQL Default Encoding
 +
<pre>
 +
default-character-set=utf8
 +
collation-server = utf8_unicode_ci
 +
init-connect='SET NAMES utf8'
 +
character-set-server = utf8
 +
default-character-set=utf8
 +
</pre>
 +
* Convert Typo3 Table
 +
<pre>
 +
mysqldump --compatible=mysql40 --opt -Q database > database.sql
 +
iconv -f iso-8859-1 -t utf8 database.sql > database-conv.sql
 +
</pre>

Version vom 1. Juli 2017, 12:11 Uhr

Error:

102: These fields are not properly updated in database: (bodytext) Probably value mismatch with fieldtype.

Solution: http://t3n.de/magazin/mysql-typo3-utf-8-umstellen-tipps-wechsel-latin1-utf-8-220945/3/

Zusammenfassung

  • Check MySQL Default Encoding
# mysql
SHOW VARIABLES LIKE 'character_set%';
SHOW VARIABLES LIKE 'collation%';
  • Set MySQL Default Encoding
default-character-set=utf8
collation-server = utf8_unicode_ci
init-connect='SET NAMES utf8'
character-set-server = utf8
default-character-set=utf8
  • Convert Typo3 Table
 mysqldump --compatible=mysql40 --opt -Q database > database.sql
 iconv -f iso-8859-1 -t utf8 database.sql > database-conv.sql