How to change the definition of the content column of qa_posts in the database?

Question

Hi gidgreen,

 

I've changed the value in QA_DB_MAX_CONTENT_LENGTH (config.php) according to your prior guide: http://www.question2answer.org/qa/3185/how-to-checnge-maximum-length-in-characters

 

But I don't know how to change the definition of the content column of qa_posts in the database to match. Could you please explain in details for me? I'm only an amateur coder :">.

 

Thank you for your support

Answer 1

You need to use a database admin tool. PHPMyAdmin is the most popular and many hosts already have it installed. You would then just go to the qa_posts table, Structure view, click edit on the content field, and change where is says 8000 to whatever your value is.

Note that if you have made the field smaller, you don't need to change the database. For example if you set it to 4000 characters, Q2A won't let anything longer than 4000 characters be stored in the database.

Comments

@DisgruntleGoat: Thank you buddy. It works fine :)