[TYPO3-team-templavoila] RFC: #10983: Unserializing problems because of UTF-8

[Tolleiv Nietsch]

This is an SVN patch request.

Type: New feature

Bugtracker references:
http://bugs.typo3.org/view.php?id=10983

Branches:
trunk

Problem:
Serialized data might break within the database when stored within a 
text-field.

Solution:
Change the field-type from "mediumtext" to "blob".

Notes:
The same decision was made within the Core-List for fields with 
serialised data ( http://bugs.typo3.org/view.php?id=12381#c31812 ).

Upgrading (changing the field-type) wasn't a problem on any of the 
tested systems (tested on the development-servers of our top 3 Clients - 
these make heavy use of FCEs and TemplaVoila) - but these run with 
proper DB settings. For systems with inproper db-settings (e.g. no "SET 
NAMES utf8") upgrading might break the mappings - but these systems have 
problems with breaking mappings anyway.

Cheers,
Tolleiv
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: 10983.patch
URL: <http://lists.typo3.org/pipermail/typo3-team-templavoila/attachments/20091029/951656b5/attachment.txt>