this post was submitted on 24 Dec 2023
98 points (96.2% liked)

Today I learned

7809 readers
1 users here now

founded 4 years ago
MODERATORS
sonder@lemmy.ml
98
TIL that SQLite has only five data types (lemmy.dbzer0.com)
submitted 9 months ago by baitsmithy@lemmy.dbzer0.com to c/todayilearned@lemmy.ml
21 comments fedilink hide all child comments
 

Learned this from a friend. The types are null, integer, real, text, and blob. My friend describes them thusly:

  • Null stores nothing, but like, actively nothing, as opposed to the absence of a thing.
  • Integer is a signed integer, up to 8 bytes.
  • Real is always an 8-byte float.
  • Text is an arbitrary-length UTF-8 or UTF-16.
  • Blob is an arbitrary-length anything-else. But I hope you remembered what you put there. Because it sure isn't gonna tell you. Oh, and it doesn't have strong typing, so if you ask for it back as an integer, it'll quite happily give you it back as an integer, especially if that doesn't make sense!
you are viewing a single comment's thread
view the rest of the comments
[–] themeatbridge@lemmy.world 4 points 9 months ago* (last edited 9 months ago) (1 children)

Ok, but is a Null Integer the same as a Null Text value? I'm really asking, I don't know.

[–] BradleyUffner@lemmy.world 5 points 9 months ago* (last edited 9 months ago) (1 children)

Conceptually, as in what the null represents at the DB level, yes. Logically, at the software level, I'd say sort of, but not really. It's complicated. Does it make sense to compare values of fundamentally different types?

[–] kogasa@programming.dev 3 points 9 months ago

In a system like Java's where everything derives from a common object class one can say null is a valid value of object type, so any two null values are equivalent. With ANSI nulls, even null isn't equivalent to null.