$6.12

Mysql how to get specific length to blob field

Ask a question+
2

I use blob filed in my MySQL table in order to store zipped content. It seems that it allows us to save up to 32KB content, but I have even bigger content to be stored. When I’m trying to set specific length to that filed, it changes nothing:

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

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

add comment

1 Answer

2

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

ALTER TABLE `crawler_url` ADD `content` MEDIUMBLOB DEFAULT NULL
Vazgen Manukyan 600
add comment

Your Answer