Pulling down emails from a mail server and saving them to a local SQLite DB using B4A.
Currently we are converting the data to Base64 and then saving it to a nvarchar however it seems every so often some special character is messing things up - crashes the routine.
Most emails are written to and read from the database, but as I mentioned every so often there seems to be something kicking up.
Is there a better more stable way to save the email body to a SQLite database than first converting to Base64 and what would be the correct data type for the column.
thanks