Tags Limit. HOWTO extend tags per item?

For some reason, when i save a product with a lot of tags, it deletes most of the tags and just displays some. How to fix it...

In number of tags to show limit in the tags settings i put: 1000000000000000000000000000

only 15 tags appear.

So i can have unlimited per item but it doesn't seem to work.

there is a limit of character in DB its 255 i think. You have to increase it. Run this query

ALTER TABLE  `bx_store_products` CHANGE  `tags`  `tags` VARCHAR( 1000 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT  '';

but please check you didn't changed any names in that table. Update this if necessary. Carefully :D

Good luck 

thanks man. I know a bit of sql soo everything cool. can i add the VARCHAR( 1000 ) to VARCHAR( 10000000000 ) ???

Nope i can't. Says the length is too big.. Need to use text it says... idk :3 hehe

anyways,, thanks. i fix it xD this worked good: 

ALTER TABLE  `bx_games_products` CHANGE  `tags`  `tags` VARCHAR( 20000 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT  '';

well you can use text or longtext if you like. It should not cause any issue.