G
G
Greg Plitt2016-08-05 14:21:54
MySQL
Greg Plitt, 2016-08-05 14:21:54

Is it possible to remove the varchar255 description bitrix character limit?

Tell me, how can I increase the description field for photos in Bitrix?
As I understand it, the limit of 255 characters is due to the varchar255 string type in the database.
I tried to change this parameter to text, but after saving the new parameter in the b_file table, all my descriptions were destroyed (empty values ​​became). I restored everything from a copy.
The question is how to get around this limitation and make descriptions for photos longer than 255 characters.
a6d37196c3fa4e6fb4b91a214a311df9.png

Answer the question

In order to leave comments, you need to log in

2 answer(s)
S
SharuPoNemnogu, 2016-08-05
@SharuPoNemnogu

what for in text to overtake? increase the size

ALTER TABLE b_file MODIFY COLUMN description VARCHAR(2000) DEFAULT NULL;

N
no_one_safe, 2016-08-05
@no_one_safe

VARCHAR in MySql has a maximum of 255 characters. No matter how you increase it, nothing will come of it
SharuPoNemnogu don't give wrong advice!
bit24yes - as an option, you can store the description in a separate field (In a new property of type text/html)

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question