Examples of Data Types in Different Systems

I'm not quite sure why I've started to pull this together. It's a simple comparison of the "fundamental data types" in a few different systems.

I think the idea is to see what types are considered most fundamental, and what the differences in these data types says about the systems themselves. A sort of "reverse-engineered" card-sorting exercise.Ultimately it's to do with thinking about "universal ontologies" -- which are things I am certain you cannot have. So why I am thinking about something that is unattainable... I do not know.

Example Data Types from c# (.Net)

(Via Built-in types - C# References)

"Value Types"

• bool
• byte
• sbyte
• char
• decimal
• double
• float
• int
• uint
• nint
• nuint
• long
• ulong
• short
• ushort

"Reference Types" (Built in)

• object
• string (including @verbatim string literals and """raw string literals""")
• dynamic
• delegate (see)

"Reference types" (more!)

• record
• class
• interface
• Nullable reference types

"void"

• void (see)

"Unmanaged types"

• (all Value types) plus:
• enum
• pointer
• tuple
• any user-defined struct with only fileds of unmanaged types

Example Data Types from SQL Server

(Via Data types (Transact-SQL))

"Exact numerics"

• tinyint
• smallint
• int
• bigint
• bit (i.e. Boolean)
• decimal (aka numeric)
• money
• smallmoney

"Approximate numerics"

• float
• real

"Date and time"

• date
• time
• datetime2
• datetimeoffset
• datetime
• smalldatetime

"Character strings"

• char
• varchar
• text

"Unicode character strings"

• nchar
• nvarchar
• ntext

"Binary strings"

• binary
• varbinary
• image

"Other data types"

• cursor
• geography
• geometry
• hierarchyid
• json
• rowversion
• sql_variant
• table
• uniqueidentifier
• xml

Example Data Types from SEQ

(Via Data types)

• 'single quoted' - strings (which we've already seen); the quote character ' can be escaped by doubling: 'Can''t'
• 123, 0.45, 0xc0ffee - numbers, internally represented as 128-bit decimal values
• 30d, 100ms - durations, specified as whole numbers of days, hours, minutes, seconds, or ms milliseconds
• true and false - Booleans
• [1, 'test', true] - arrays with [0] (zero-based) numeric indexing
• {ace: 1, 'beta gamma': 23} - object literals with string or identifier keys
• null

Sources

• Built-in types - C# References
• Data types (Transact-SQL)
• SEQ Query Language #Data types