[TYPO3-core] RFC: Getting rid of blob fields in TYPO3 databases

[Michael Stucki]

Be careful with this change! We just discovered a problem last week which was 
caused by our BLOB to TEXT migration: http://bugs.typo3.org/view.php?id=5088

Keeping blob types for some fields seems to be the quick workaround, but the 
real problem is that people who migrate their sites have probably not 
converted all tables correctly. In this case the sys_template table contained 
ISO-8859-1 characters but cache_hash.content was set to UTF-8.

The long-term solution is either a conversion utility, a comparison check 
(requires additional queries) or charset conversion on TypoScript level.

- michael

Am Montag, 19. März 2007 10:18 schrieb Dmitry Dulepov:
> Patrick Broens wrote:
> > This bug is documented in
> > http://bugs.typo3.org/view.php?id=3547
> > http://bugs.typo3.org/view.php?id=3303
> >
> > Changing the BLOB to TEXT fields solve these issues.
>
> Do we need anything else to do?
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
Url : http://lists.netfielders.de/pipermail/typo3-team-core/attachments/20070319/ca99844d/attachment.pgp