[TYPO3-english] Duplicate cHash values

Dmitry Dulepov dmitry at typo3.org
Mon Jan 19 14:21:43 CET 2009


Hi!

Dmitry Martynenko wrote:
> Now I have tx_realurl_chashcache table like (it differs from standart
> RealURL table - spurl_hash already store full MD5 value):
> 
> CREATE TABLE `tx_realurl_chashcache` (
>   `spurl_hash` VARCHAR(32) NOT NULL DEFAULT '',
>   `chash_string` VARCHAR(10) NOT NULL DEFAULT '',
> )
> 
> If extend chash_string to full MD5 it will be VARCHAR(32),
> and each record will occupy 64 bytes.
> 
> But if use BINARY(16) for both fields, then each record will occupy only 32 bytes.

Yes, it is possible.

-- 
Dmitry Dulepov
TYPO3 core team
"Sometimes they go bad. No one knows why" (Cameron, TSCC, "Dungeons&Dragons")


More information about the TYPO3-english mailing list