Convert a image to base64 and then trying to save in database

[csplrj]

Convert a image to base64 and then trying to save in database but it
throws exception saying that "SQL statement is too long." Is there any
way out for this

Thanks in advance

CSJakharia

[Kevin Layman]

Is there some reason you can't just store it as a blob?

[csplrj]

How to use store image as a blob?
I mean I used filereader and it gives base64. How can I get blob
object?

Thanks in advance

CSJakharia

[Kevin Layman]

Try writing that to a column of type blob and see if that will work. If it doesn't I think I read that Gears already chunks text data that exceeds the length limit that can be handled by sqlite so I don't think chunking it will help but it might be worth a try anyway. Experiment a little with difference sized pics and see if its size-related or something else.