Welcome to the Question2Answer Q&A. There's also a demo if you just want to try it out.

Increase answer length from 12000 to 50000 in q2a 1.8.0?

+1 vote
124 views
asked May 14 in Q2A Core by ruhu
Hi, I have changed the content varchar(50000) from varchar(12000) and also change QA_DB_MAX_CONTENT_LENGTH in maxima.php . But not working. Please let me know about more settings or some thing.

1 Answer

0 votes
answered May 15 by pupi1985
It is not possible to set the field to VARCHAR(50000). If you try to do so, the operation will succeed but if you check the field you will see it as a MEDIUMTEXT or another TEXT-family type.

Up to version 1.8.0, the maximum size without the automatic conversion is between 20.000 and 30.000.

What is weird is that you say it doesn't work because the MEDIUMTEXT can store up to 16.777.215 bytes. So if you have updated the QA_DB_MAX_CONTENT_LENGTH constant properly you should be good. You might be doing something else wrong.

More information here: http://www.question2answer.org/qa/39622
...