Amaresh Amaresh - 1 year ago 137
Android Question

Is SQLite database support MEDIUMTEXT like MySQL in android?

I have seen that MySQL is supporting the MEDIUMTEXT which can store around 16mb of data and LONGTEXT is supporting around 4gb of data. Does SQLite support mediumtext ?. Thanks in advance....

Answer Source

SQLite has only a single string data type.

The documentation says:

Maximum length of a string or BLOB
The maximum number of bytes in a string or BLOB in SQLite is defined by the preprocessor macro SQLITE_MAX_LENGTH. The default value of this macro is 1 billion (1 thousand million or 1,000,000,000).

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download