Re: [sqlite] getting error "string or blob too big" for 500 MB data insertion

[Richard Hipp]

On 12/8/17, Durgesh  wrote:
> I am trying to insert 500 MB of row data using Qt SQL into sqlite db.

How are you measuring the row size?

>
> Insertion is successful up to 450 MB.
>
> defined macro SQLITE_MAX_LENGTH to larger value than 500 MB, as mentioned in
> http://www.sqlite.org/limits.html
>
> Still getting above error while insertion.
>
>
>
>
>
> --
> Sent from: http://sqlite.1065341.n5.nabble.com/
> ___
> sqlite-users mailing list
> sqlite-users@mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>


-- 
D. Richard Hipp
d...@sqlite.org
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] getting error "string or blob too big" for 500 MB data insertion

[Durgesh]

I am trying to insert 500 MB of row data using Qt SQL into sqlite db.

Insertion is successful up to 450 MB.

defined macro SQLITE_MAX_LENGTH to larger value than 500 MB, as mentioned in
http://www.sqlite.org/limits.html

Still getting above error while insertion.





--
Sent from: http://sqlite.1065341.n5.nabble.com/
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users