Android Question Saving Email Body to SQLite

[Krammig]

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

 

[bokinet]

Maybe it's funny but can you try to encrypt it or even use some compression which should be byte safe and then do base64 and store to db.
Also, code page which is used for e-mails body you should check as well and do byte safe encoding/decoding too.

 

[Krammig]

Thanks will give that a try