SQL Data Type Reference

Summary

Compare SQL data types side-by-side across MySQL, PostgreSQL, SQLite, and SQL Server — searchable and filterable by category.

How it works

1. Use the search box to filter rows by type name or description.
2. Click a category badge to show only that group of types.
3. Each row shows the equivalent type (or N/A) in all four databases.
4. Storage size and notes columns give extra context for each type.
5. Click "Reset" or the active filter badge to clear the filter.

Use cases

• Look up the PostgreSQL equivalent of a MySQL INT or VARCHAR.
• Find which SQL Server type maps to PostgreSQL JSONB.
• Check storage sizes when optimizing schema for performance.
• Quickly compare boolean handling differences across databases.
• Reference date/time types when migrating from MySQL to PostgreSQL.
• Understand which types are natively supported vs. emulated in SQLite.
• Learn the range and precision of numeric types before choosing one.
• Train junior developers on SQL type fundamentals across platforms.

Frequently Asked Questions