Re: [sqlite] max size of a TEXT field

2012-07-03 Thread nobre
http://www.sqlite.org/limits.html -- View this message in context: http://sqlite.1065341.n5.nabble.com/max-size-of-a-TEXT-field-tp63069p63070.html Sent from the SQLite mailing list archive at Nabble.com. ___ sqlite-users mailing list

[sqlite] max size of a TEXT field

2012-07-02 Thread deltagam...@gmx.net
Hello, I couldnt find in the documentation what the max size of TEXT field/column is. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] max size of a TEXT field

2012-07-02 Thread Igor Tandetnik
On 7/2/2012 4:02 PM, deltagam...@gmx.net wrote: I couldnt find in the documentation what the max size of TEXT field/column is. There's no set limit. As much as can fit into memory, basically. -- Igor Tandetnik ___ sqlite-users mailing list

Re: [sqlite] max size of a TEXT field

2012-07-02 Thread Pavel Ivanov
On Mon, Jul 2, 2012 at 4:02 PM, deltagam...@gmx.net deltagam...@gmx.net wrote: Hello, I couldnt find in the documentation what the max size of TEXT field/column is. http://www.sqlite.org/limits.html#max_length By default it's 10^9 bytes and cannot be more than 2^31 - 1. Pavel

Re: [sqlite] max size of a TEXT field

2012-07-02 Thread Jay A. Kreibich
On Mon, Jul 02, 2012 at 10:02:29PM +0200, deltagam...@gmx.net scratched on the wall: Hello, I couldnt find in the documentation what the max size of TEXT field/column is. First item: http://sqlite.org/limits.html#max_length By default, 10^9 bytes (~1GB). Can be altered, but there is

Re: [sqlite] max size of a TEXT field

2012-07-02 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 02/07/12 13:20, Jay A. Kreibich wrote: By default, 10^9 bytes (~1GB). Can be altered, but there is a hard limit of (2^31 - 1), or 2GB. Even more subtleties than that. SQLite's internals are fundamentally 32 bits even on 64 bit platforms. For