Conversation

SQLite only has a single INTEGER type encoding 64-bit integers as a variable length integer. sqlite.org/datatype3.html Columns in SQLite have a preferred storage format (affinity) rather than types. sqlite.org/datatype3.html BIGINT is one of many aliases for INTEGER affinity.

dade

@0xdade

Aug 26, 2020

Replying to

@DanielMicay

and

@RichFelker

Yes, that is a long winded way of saying what I said, thanks.

Replying to

and

I'm clarifying for

that BIGINT is part of SQLite's compatibility cruft for column type names. It doesn't have a BIGINT type and they inherited those alias names as cruft from every other mainstream database. It's worth reading what I linked to see what a mess that is.

3:36 AM · Aug 26, 2020Twitter Web App

Replying to

and

"BIGINT" isn't even explicitly an alias for INTEGER affinity. Every type name containing the string "INT" is an alias for INTEGER. They give the example of "FLOATING POINT" mapping to INTEGER affinity because "INT" is matched before the rule for "FLOA". It's pretty gross.