|
|
Yes. But I found a workaround/fix:
The problem is that the database field for this information is a varchar with only 255 characters.
A simple workaround I did, was to update this field for 20.000 characters:
ALTER TABLE `custom_fields_values` CHANGE `value_charvalue` `value_charvalue` VARCHAR (20000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL
But I realized that this field is a part of a index, so, it could down the performance.
Then, I did two more updates:
1. Droped the index:
ALTER TABLE `custom_fields_values` DROP INDEX `value_charvalue`
2. Changed the field for TEXT type:
ALTER TABLE `custom_fields_values` CHANGE `value_charvalue` `value_charvalue` TEXT CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL
Now it works great. I would like to recomend that the default database schema could be changed for this type of field.
Thanks a lot.
Marcelo Fenoll, from Brazil. |
|