SQL DataType – How to store a year?

by

regular 4 byte INT is way too big, is a waste of space!

You don’t say what database you’re using, so I can’t recommend a specific datatype. Everyone is saying “use integer”, but most databases store integers as 4 bytes, which is way more than you need. You should use a two byte integer (smallint on SQL Server), which will conserve space.

More Related Contents:

  1. Is it a good idea to use an integer column for storing US ZIP codes in a database?
  2. Version of SQLite used in Android?
  3. What are the performance characteristics of sqlite with very large database files? [closed]
  4. What are database normal forms and can you give examples? [closed]
  5. Exposing database IDs – security risk?
  6. How can I put a database under git (version control)?
  7. Is there any boolean type in Oracle databases?
  8. How to use mongoimport to import csv
  9. NoSql vs Relational database
  10. How to recover a corrupt SQLite3 database?
  11. How do IMMUTABLE, STABLE and VOLATILE keywords effect behaviour of function?
  12. Best way to test a MS Access application?
  13. Partial Dependency (Databases)
  14. How to display table data more clearly in oracle sqlplus
  15. Can I rollback a transaction I’ve already committed? (data loss)
  16. internationalization in JSF with ResourceBundle entries which are loaded from database
  17. Kill a postgresql session/connection
  18. What is the most efficient way to store tags in a database?
  19. How to backup sqlite database?
  20. Microservices with shared database? using multiple ORM’s? [closed]
  21. What’s the best strategy for unit-testing database-driven applications?
  22. What are the use cases of Graph-based Databases (http://neo4j.org/)? [closed]
  23. Saving images: files or blobs?
  24. Still Confused About Identifying vs. Non-Identifying Relationships
  25. Normal forms – 2nd vs 3rd – is the difference just composite keys? non trivial dependency?
  26. Is there any NoSQL data store that is ACID compliant?
  27. How to think in data stores instead of databases?
  28. Is it better to use multiple databases with one schema each, or one database with multiple schemas? [closed]
  29. Connect to a heroku database with pgadmin
  30. Starting and populating a Postgres container in Docker

Leave a Comment