search

JaimieMurdock / lastfm

2 stars 0 forks source link

Length of item_url column #1

Open JaimieMurdock opened 10 years ago

JaimieMurdock commented 10 years ago

The column lastfm_bannedtracks.item_url is not yet updated to the new schema.

The proposed change is:

ALTER TABLE `crawler_lastfm`.`lastfm_bannedtracks`
CHANGE COLUMN `item_url` `item_url` VARCHAR(700) CHARACTER SET 'utf8' NOT NULL;

However this results in the following error:

ERROR 1071 (42000) at line 1: Specified key was too long; max key length is 767 bytes
moustachio commented 10 years ago

This shouldn't matter now under the newly updated bannedtracks table that I've already implemented. The issues with the max key length is resolved by the fact that everything is in latin1, not utf8. This is fine because all urls are stored using html escape codes as appropriate (e.g. "dälek" is recorded as "d%c3%a4lek"). In any case, raw urls only now appear in lastfm_itemlist.