Mysql how to get specific length to blob field

Ask a question
1

I use blob filed in my mysql table in order to store zippetd content. Seems that it allos to save up to 32KB content but I have even bigger content to be stored. When I’m tying tyo set specefic length to that filed it changes nothing:

ALTER TABLE `crawler_url` CHANGE `content` `content` BLOB NULL DEFAULT NULL;

I tryied to use text or medium text type but they don’t allow to store zipped data. So how to increase blob filed length in mysql?

Coin iconoffer bounty
add comment

1 Answer

2

found a solution, I have just converted blob to medium blob.

ALTER TABLE `crawler_url` ADD `content` MEDIUMBLOB DEFAULT NULL
add comment

Your Answer