{"id":82,"date":"2010-03-17T18:16:32","date_gmt":"2010-03-17T18:16:32","guid":{"rendered":"https:\/\/www.taywa.ch\/blog\/?p=82"},"modified":"2010-03-17T18:20:16","modified_gmt":"2010-03-17T18:20:16","slug":"typo3-installation-und-mysql-datenbank-auf-russisch-in-utf8","status":"publish","type":"post","link":"https:\/\/www.taywa.ch\/blog\/typo3\/typo3_setup\/typo3-installation-und-mysql-datenbank-auf-russisch-in-utf8\/","title":{"rendered":"typo3 installation (und MySQL Datenbank) auf russisch in utf8"},"content":{"rendered":"

Problem:<\/strong> M\u00f6chte man in einer typo3 installation russische texte abspeichern kommt folgende fehlermeldung:
\n102: These fields are not properly updated in database: (username) Probably value mismatch with fieldtype.<\/p>\n

L\u00f6sung:<\/strong>
\nIm typoscript nach dem initialisieren des page Objektes folgende Zeilen einf\u00fcgen (stellt das frontend auf utf8 um):<\/p>\n

page<\/span>.<\/span>config.<\/span>metaCharset =<\/span> utf-8<\/span>
\npage<\/span>.<\/span>config.<\/span>additionalHeaders =<\/span> Content-Type:<\/span>text\/<\/span>html;charset=<\/span>utf-8<\/span><\/div>\n

Dann in der localconf.php (oder im install tool) mindestens die erste zeile des folgenden codeblocks einsetzen:<\/p>\n

$TYPO3_CONF_VARS<\/span>[<\/span>‚BE‘<\/span>]<\/span>[<\/span>‚forceCharset‘<\/span>]<\/span> =<\/span> ‚utf-8‘<\/span>;<\/span> \/\/setzt das admin-interface auf utf8 – ZWINGEND<\/span><\/p>\n

\n\/\/Weitere je nach Fall relevante Einstellungen:<\/span>
\n$TYPO3_CONF_VARS<\/span>[<\/span>‚SYS‘<\/span>]<\/span>[<\/span>‚multiplyDBfieldSize‘<\/span>]<\/span> =<\/span> ‚3‘<\/span>;<\/span> \/\/ k\u00f6nnte helfen, muss nicht gesetzt werden, wenn die DB in utf8 ist<\/span>
\n$TYPO3_CONF_VARS<\/span>[<\/span>‚SYS‘<\/span>]<\/span>[<\/span>’setDBinit‘<\/span>]<\/span> =<\/span> ‚SET NAMES utf8;‘<\/span>.<\/span>chr<\/span><\/a>(<\/span>10<\/span>)<\/span>.<\/span>‚SET CHARACTER_SET utf8;‘<\/span>.<\/span>chr<\/span><\/a>(<\/span>10<\/span>)<\/span>.<\/span>‚SET SESSION character_set_server=utf8;‘<\/span>;<\/span>
\n$TYPO3_CONF_VARS<\/span>[<\/span>‚SYS‘<\/span>]<\/span>[<\/span>‚t3lib_cs_convMethod‘<\/span>]<\/span> =<\/span> ‚mbstring‘<\/span>;<\/span>
\n$TYPO3_CONF_VARS<\/span>[<\/span>‚SYS‘<\/span>]<\/span>[<\/span>‚t3lib_cs_utils‘<\/span>]<\/span> =<\/span> ‚mbstring‘<\/span>;<\/span><\/div>\n

Zuletzt, wenn’s immer noch nicht klappt, die Datenbank auf im phpmyadmin utf8 umstellen und dann einige Tabellen:<\/p>\n

ALTER<\/span> TABLE<\/span> tt_content CONVERT TO<\/span> CHARACTER SET<\/span> utf8;
\nALTER<\/span> TABLE<\/span> pages_language_overlay CONVERT TO<\/span> CHARACTER SET<\/span> utf8;
\nALTER<\/span> TABLE<\/span> sys_language CONVERT TO<\/span> CHARACTER SET<\/span> utf8;<\/div>\n

Weitere Links:
\nhttp:\/\/wiki.typo3.org\/index.php\/UFT-8_support<\/a>
\nhttp:\/\/www.typo3forum.net\/forum\/typo3-4-x-fragen-probleme\/43438-russische-sprache.html<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Problem: M\u00f6chte man in einer typo3 installation russische texte abspeichern kommt folgende fehlermeldung: 102: These fields are not properly updated in database: (username) Probably value mismatch with fieldtype. L\u00f6sung: Im typoscript nach dem initialisieren des page Objektes folgende Zeilen einf\u00fcgen (stellt das frontend auf utf8 um): page.config.metaCharset = utf-8 page.config.additionalHeaders = Content-Type:text\/html;charset=utf-8 Dann in der<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12,11],"tags":[53,55,185,180,181,52],"class_list":["post-82","post","type-post","status-publish","format-standard","hentry","category-mysql","category-typo3_setup","tag-installation","tag-localconf-php","tag-mysql","tag-typo3","tag-typoscript","tag-utf8"],"_links":{"self":[{"href":"https:\/\/www.taywa.ch\/blog\/wp-json\/wp\/v2\/posts\/82","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.taywa.ch\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.taywa.ch\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.taywa.ch\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.taywa.ch\/blog\/wp-json\/wp\/v2\/comments?post=82"}],"version-history":[{"count":7,"href":"https:\/\/www.taywa.ch\/blog\/wp-json\/wp\/v2\/posts\/82\/revisions"}],"predecessor-version":[{"id":89,"href":"https:\/\/www.taywa.ch\/blog\/wp-json\/wp\/v2\/posts\/82\/revisions\/89"}],"wp:attachment":[{"href":"https:\/\/www.taywa.ch\/blog\/wp-json\/wp\/v2\/media?parent=82"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.taywa.ch\/blog\/wp-json\/wp\/v2\/categories?post=82"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.taywa.ch\/blog\/wp-json\/wp\/v2\/tags?post=82"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}