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-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 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 example the APIs that pass data around
use 'int' which is 32 bit even on 64 bit platforms (ie the limits don't
change just by using 64 bits).

You can ask for data in UTF16 which uses a minimum of 2 bytes per
codepoint while UTF8 (the default) uses a minimum of one byte per
codepoint.  Consequently if you had a 1.1 billion codepoints in the
database itself (stored in UTF8), then you couldn't retrieve is as UTF16
because it would exceed signed 32 bit ints being used.  Lest you think
everyone is UTF8, the "normal" size for Java and Windows is UTF16.

Also the worst case for UTF8 is 6 bytes per codepoint, although they are rare.

The net consequence is that the largest size is really 1 billion
codepoints, otherwise some platforms using UTF16 will have problems.  And
if you want to be absolutely certain then the maximum is one sixth of that.

For the folks who don't know what codepoints are, or what the Unicode fuss
is then read this article titled "The Absolute Minimum Every Software
Developer Absolutely, Positively Must Know About Unicode and Character Sets"

  http://www.joelonsoftware.com/articles/Unicode.html

Roger
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.11 (GNU/Linux)

iEYEARECAAYFAk/yDNUACgkQmOOfHg372QR9twCeOP3rtAc1nbQ0gHFYL8Y97y+H
U+0AoKYpYW13yfnyKEExq2t+tgUQ+Ppb
=1cpR
-END PGP SIGNATURE-
___
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 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 a hard
  limit of (2^31 - 1), or 2GB.

   -j

-- 
Jay A. Kreibich < J A Y  @  K R E I B I.C H >

"Intelligence is like underwear: it is important that you have it,
 but showing it to the wrong people has the tendency to make them
 feel uncomfortable." -- Angela Johnson
___
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 Pavel Ivanov 
On Mon, Jul 2, 2012 at 4:02 PM, 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
___
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
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[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