Comments not staying

[atkins513]

Hey team,
I am having some issues with comments and was hoping you could help. My text of the comments section constantly gets cut off. It's just not enough to add all the comments I need to for most things and I constantly run out of room or get cut off. I found a way to increase the Characters of comments to 500 or more via a Mysql command, but I am also somewhat of a novice with some of these things.
I know how to load Putty, connect and make commands, but the exact steps are a little beyond me. I found another post on the forum that went into detail about how to do this. Can you clarify these steps for me, step by step so that I can increase my comments characters to 500. Below is the original post. Thank you so much.
VERSION: 2.14-634c BUILD: 210421-2110


------------------------------------
dreedy » Thu May 17, 2018 4:14 pm
" IF I ALTER the comments field in the MYSQL to a VARCHAR (500) that this would enable the comments to go to 500 characters ? and would i need to expanded the agent and admin screen reference to allow the comment to be seen in one screen? "

The Response: mflorell » Thu May 17, 2018 9:46 pm
Yes, you can change the comments to VARCHAR(500) if you want and it should not cause any problems.

dreedy » Fri May 18, 2018 10:34 am
Thank you all i have tested this out and had to alter 2 places for the comments. vicidial_list and vicidial_comments. once i altered that to expand the store capacity to 500 char the information would go to 500 char. "
------------------------------------

[carpenox]

yes that is correct, you can use the alter command to change varchar to 500

[williamconley]

You can also change it to TEXT which has NO limit. And you can modify the system to push notes into historical notes after each call to get something more akin to "logs of calls".