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