Design decision for datatypes while creating tables

 Hi All,

char or nvarchar 

 

https://www.mssqltips.com/sqlservertip/4322/sql-server-differences-of-char-nchar-varchar-and-nvarchar-data-types/ 

 

int ot tinyint 

https://dev.mysql.com/doc/refman/8.0/en/integer-types.html 

 

 

datetime or datetime2 

https://database.guide/datetime-vs-datetime2-in-sql-server-whats-the-difference/ 

https://docs.informatica.com/data-engineering/data-engineering-integration/10-2/powerexchange-for-microsoft-azure-sql-data-warehouse-user-guide/microsoft-azure-sql-data-warehouse-datatype-reference/microsoft-azure-sql-data-warehouse-and-transformation-datatypes.html