[prev in list] [next in list] [prev in thread] [next in thread] 

List:       sqlite-users
Subject:    Re: [sqlite] [solved] SQLite won't import 53, 066,
From:       Roger Binns <rogerb () rogerbinns ! com>
Date:       2009-11-28 19:36:44
Message-ID: 4B117BCC.80205 () rogerbinns ! com
[Download RAW message or body]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Simon Slavin wrote:
> On 28 Nov 2009, at 3:55pm, Walter Dnes wrote:
> 
> > ...and import worked.  So it appears that the maximum csv file is probably
> > around 2 gigabytes.
> 
> That does make sense of some kind, but it indicates that someone is using signed \
> integers for file sizes.  Signed would be about 2 gigabytes, unsigned would give \
> you about 4.

The file size type is off_t which turns out to be signed on most systems.
Hence 2GB limit makes perfect sense.

  http://www.sqlite.org/src/info/92af7da36b

Roger
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iEYEARECAAYFAksRe8kACgkQmOOfHg372QT85gCfZzXw4ko1asuwFVbPykKLlzqj
5aYAnjreUB0bTZp9xROSIRs9VFcoWGd8
=NjW5
-----END PGP SIGNATURE-----
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


[prev in list] [next in list] [prev in thread] [next in thread]