Issue Bug Closed

#19193Charset problems if caching is not enabled (config.no_cache = 1)

Andreas Dörler 08/04/08, 22:47 updated 10/02/18, 12:29

Description

Typo3 4.2.1
PHP 5.2.0-8+etch10
MySQL 5.0.32

DB, Typo3-FE & -BE is using utf-8. typo3conf

$TYPO3_CONF_VARS[‘BE’][‘forceCharset’] = ‘utf-8’;
$TYPO3_CONF_VARS[‘SYS’][‘setDBinit’] = ‘SET NAMES utf8;’;

mysql> show variables where variable_name like ‘char’;
+—————————————+——————————————+ | Variable_name | Value |
+—————————————+——————————————+ | character_set_client | utf8 | | character_set_connection | utf8 | | character_set_database | utf8 | | character_set_filesystem | binary | | character_set_results | utf8 | | character_set_server | utf8 | | character_set_system | utf8 | | character_sets_dir | /usr/share/mysql/charsets/ |
+—————————————+——————————————+

Insert a HTML-Element on any page with content “»” is working without problems, as long as “config.no_cache = 1” is set.

After enabling caching “»” results in an unknown symbol (=> ?) and the html-source stored in the field “HTML” in table “cache_pages” is cut off after this point. On next reload the cached (but destroyed) source is delivered to the browser.

If I insert the Symbol by copy&paste from a Website like http://unicode.e-workers.de/entities.php everything works OK. But this is no solution, as for example newscalendar uses “»” and “«” for navigation etc…

I could not reproduce this error on another typo3-installation at the same server, but cannot see any significant difference between the installations.

The field “HTML” in “cache_pages” is “mediumtext”, could this issue be related to something like this:

2007-04-02 Michael Stucki <michael> <ul> <li>Fixed bug #17053: Cache is not saved properly because of charset conflict in the database. Changing the field type of cache_hash.content from mediumtext to mediumblob. To make this work, you need to compare your database in the Install Tool.</li> </ul> <p>=&gt; After changing fieldtype to mediumblob, the whole source is saved into “HTML”, but “»” is still an unknown symbol in the FE.<br>(issue imported from #M9120)</p></michael>

Reviews 0

No change resolves or names this issue in its commit message, and no comment links one.