Custom Profile Field Length

I added a custom field in the profile fields called:



Any Comments



And it works for the most part, but apparently she has some clients that put in huge paragraphs in to that field. I'm not sure why, but it is what it is.



Unfortunately the field won't fit enough characters in it for what her customers do. How can I increase the number of allowed characters for the field.



Thanks,



Brandon

In DB table cscart_profile_fields_data, change the 'value' field type from 'varchar(255)' to 'text'. I did this on my V2 store and the database structure is the same for the 'profiles' tables in V3 too, so this should work for both. I haven't looked into changing this for V4 yet but you should be able to find the corresponding field in the database and change the maximum value.



Also, if you use one of the Store Import tools (ie. from V2>V3 or to V4) then ensure you change this value in the target (new) database, as it will default back to 255 characters and strip anything thereafter when doing the store import.