Page 1 of 1
Character limit - Terms and Conditions
Posted: Fri Feb 17, 2012 6:48 am
by jrb1
Hi, I'm using OC 1.5.1.3 there seems to be a character limit set in the Information section where I want to paste my Terms & Conditions. When I paste my terms & conditions only half of the information is saved. Does anyone know how to increase this limit?
Thanks in advance.
Re: Character limit - Terms and Conditions
Posted: Fri Feb 17, 2012 7:06 am
by fido-x
The description field for information pages is a "text" field, which allows for something like 32,768 characters (you can't increase this). The only validation done is to check that there is a minimum of 3 characters.
You shouldn't be having any issues with the length of your Terms & Conditions, unless you're trying to paste into the wrong field.
Re: Character limit - Terms and Conditions
Posted: Fri Feb 17, 2012 7:14 am
by jrb1
Hi Fido-x
Thanks for the quick reply - I've just checked, my terms & conditions have 58,100 characters. There in lies the problem.
Julian
Re: Character limit - Terms and Conditions
Posted: Fri Feb 17, 2012 3:15 pm
by rph
Code: Select all
ALTER TABLE `information_description` CHANGE `description` `description` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL
EDIT: For those looking for more explanation, the above is an SQL query which you can run in phpmyadmin. It changes description from TEXT which has a 64KB limit to MEDIUMTEXT which has a 16MB limit.
Re: Character limit - Terms and Conditions
Posted: Sat Feb 18, 2012 3:34 am
by jrb1
Thanks for your help Ryan
Worked perfectly
Cheers
Re: Character limit - Terms and Conditions
Posted: Sat Feb 18, 2012 3:55 am
by rph
No problem.
Re: Character limit - Terms and Conditions
Posted: Tue Jun 21, 2016 2:03 pm
by Krammig
I cannot believe after all these years this is still an issue with Opencart.
I have been sitting here for a good amount of time trying to work out why the Description field was truncating my data. So frustrating.
Thanks Ryan this fixed my problem.
Perhaps the Opencart team can get their act together enough to update this issue.
cheers
Re: Character limit - Terms and Conditions
Posted: Thu Sep 22, 2016 11:21 pm
by zjasper
Thanks a lot! It is a pitty it is still limited in version 2.3.02.
Re: Character limit - Terms and Conditions
Posted: Thu Dec 01, 2016 11:17 pm
by richardvaneck
Works still great with opencart 2.3.0.2
Code: Select all
ALTER TABLE `oc_information_description` CHANGE `description` `description` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_bin NOT NULL