SQLite booleans?

Discussion in 'Questions (Windows Mobile)' started by N1c0_ds, Mar 16, 2009.

  1. N1c0_ds

    N1c0_ds Active Member Licensed User

    I was wondering if the BOOLEAN SQLite data type worked with Basic4PPC. I've heard about trouble with it, but it would save a lot of room if I could use it. Can anyone testify?

    PS: I use SQLite Expert, as recommended by a fellow member
    Last edited: Mar 16, 2009
  2. RB Smissaert

    RB Smissaert Well-Known Member Licensed User

    BOOLEAN SQLite data type?

    From the SQLite website (SQLite Frequently Asked Questions
    SQLite uses dynamic typing.
    Content can be stored as INTEGER, REAL, TEXT, BLOB, or as NULL.
    So, you are best of to store as integer, so 0 or 1. Requires just one Byte.

  3. N1c0_ds

    N1c0_ds Active Member Licensed User

    Cool, thanks!

    UPDATE: Apparently that's exactly how Booleans work: 1 or 0!
    Last edited: Mar 18, 2009
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice