-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Navaneeth Sen B wrote: > Could somebody explain this to me :
Which bit in particular is confusing? SQLITE_MAX_SQL_LENGTH is a C define so you can change it by adding "-DSQLITE_MAX_SQL_LENGTH=999" to the compiler invocation for sqlite3.c. The reason for the limit in the first place is because (for historical reasons) SQLite uses 'int' as the type for sizes which is limited to signed 32 bits even on 64 bit platforms. That gives a practical limit of 2GB but 1GB is the upper limit because UTF16 expansion could result in 2GB of text. (Changing the type would break the ABI or require introducing new versions of several of the public API functions.) Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAku0Tl4ACgkQmOOfHg372QRGqwCfRwBPZFX1xv1rGlTUEdob9BO4 EpwAoNzml7x8bUe9IPPQMSYTZsNwq72a =2IIN -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
