H
H
HexUserHex2020-05-11 22:31:12
SQLite
HexUserHex, 2020-05-11 22:31:12

What is the maximum value that can be written to a Sqlite field?

It is required to save some images in the database (I know that this is still a crutch, but alas ....) I am aware of normalization, etc.) here we are talking about saving as quickly as possible) My procedure is simple: the image in base64 and then in the database. Pictures are small, BUT on average already in base64 they weigh 20000-35000 characters ... actually the question is how much can be stored maximum in the same TEXT ?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
S
Sergey Karbivnichy, 2020-05-11
@HexUserHex

The maximum length of a row or BLOB field is 1,000,000,000
SQLite Restrictions

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question