> As long as your values are within the range of -128 to +127, your
> integers will only take one byte of storage (plus common overhead).
>
There's an extra byte of meta data for each column value in each
row due to manifest typing, so an int will take at least 2 bytes
of storage per colu
On Fri, Oct 24, 2008 at 02:49:14AM -0700, dbikash scratched on the wall:
>
> Hi,
>
> I am using tinyint in my schema, but while doing paramterized insertion, I
> find that there is no specific bind API to insert a tinyint. So I used int
> sqlite3_bind_int() instead.
>
> However, the size of my d
On Fri, Oct 24, 2008 at 2:49 AM, dbikash <[EMAIL PROTECTED]> wrote:
>
> Hi,
>
> I am using tinyint in my schema, but while doing paramterized insertion, I
> find that there is no specific bind API to insert a tinyint. So I used int
> sqlite3_bind_int() instead.
>
> However, the size of my database
Hi,
I am using tinyint in my schema, but while doing paramterized insertion, I
find that there is no specific bind API to insert a tinyint. So I used int
sqlite3_bind_int() instead.
However, the size of my database suggests that SQLite might actually be
using 4 bytes instead of 1. Is it? How can
4 matches
Mail list logo