Which table used to store encrypted chat

Hi , can any one please tell me which table is used to store encrypted chat and which client application i used that supports encrypted chat for windows. currently i am using spark and pidgin client

Thank You

What do you mean by encrypted? Openfire can store chat history via Monitoring Service plugin, but it is not encrypted. If you mean OTR or OMEMO, then i think it can’t be stored in a server in a readable format.