On 12/10/08, Satish <[EMAIL PROTECTED]> wrote: > Hi, > I have seen the link which you sent.I didn't found any thing in > which you sent regarding the size of number or text > Field.In the link which u sent there mentioned the size limit of blob I > didn't found any size limit regarding text and number.Can I assume the size > of number and text as unlimited.
The very first item in the link that Martin sent 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). You can raise or lower this value at compile-time using a command-line option like this: -DSQLITE_MAX_LENGTH=123456789" See that part about "string"? > > Regards, > G.Satish. > > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Martin.Engelschalk > Sent: Wednesday, December 10, 2008 5:45 PM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] Maximum Size of Record > > Hi, > > See http://www.sqlite.org/limits.html > > Martin > Satish schrieb: > > Hi Igor, > > > > Can I know the Maximum size of Record in sqlite or Can I > > know the maximum size of NUMBER,TEXT and BLOB Data types. > > > > > > > > Regards, > > > > G.Satish. > > > > _______________________________________________ > > sqlite-users mailing list > > sqlite-users@sqlite.org > > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Puneet Kishor http://www.punkish.org/ Nelson Institute for Environmental Studies http://www.nelson.wisc.edu/ Open Source Geospatial Foundation (OSGeo) http://www.osgeo.org/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
