[TYPO3-core] RFC: replace tinytext fields by varchar(255)

[Karsten Dambekalns]

Hi.

On 11.03.2007, at 18:50, Martin Kutschker wrote:
> TINYTEXT fields serve no real purpose and can be replaced by VARCHAR 
> (255). This has an advantage for DBAL on some systems (they are  
> more "expensive")

+1

> Next steps for a DBAL cleanup are:
>
> * remove all UNSIGNED definitions of INTs
> * replace all BLOB with TEXT fields

Fine with me. Integers have their unsigned dropped anyway for DBAL.
Note: For MySQL we need to take care that range is adapted if needed  
- unsigned tinyint stores 0..256 whereas signed tinyint stores  
-128...128 and therefore would break by simply removing the unsigned  
attribute.

BLOBS should be replaced wherever possible, full ack.

Regards,
Karsten
-- 
Karsten Dambekalns
Gimme Five!
http://typo3.org/gimmefive


-------------- next part --------------
A non-text attachment was scrubbed...
Name: PGP.sig
Type: application/pgp-signature
Size: 304 bytes
Desc: This is a digitally signed message part
Url : http://lists.netfielders.de/pipermail/typo3-team-core/attachments/20070312/1bce3f90/attachment.pgp