We have a requirement to upload before and after pictures, can we use rich text area field ? Which storage category does Rich text area field comes into - data storage or file storage ?
Help docs seem to answer all your questions:
The maximum size of an image that can be uploaded in a rich text area field is 1 MB. Only .gif, .jpg, and .png file types are supported.
Images within the rich text area fields count towards file storage for the object that contains the field.
You can use XL-Connector to mass upload/download images to Rich Text Area fields.
Simply paste pictures into cells and run the Update or Insert DML operation to upload. Simply run a SOQL query to download.