Is VARCHAR like totally 1990s? [closed]
You match the datatype with the data that will be stored in the column. By a similar argument you could say why not store all data in NVARCHAR columns, because numbers and dates can be represented as strings of digits.
If the best match for the data that will be stored in the column is VARCHAR, then use it.
Point 4 doesn't matter because storage space is extremely inexpensive.
it is not just storage, but bandwidth - cpu, memory, backup, recovery, transfer. Conserve.
I'd say that there are still valid reasons to not use nvarchar.
- Storage space is at a premium, such as on a shared host or the database isreally huge.
- Performance is critical.
- Brownfield development (i.e. the database has existing tables that use varchar).
- You are integrating with another older system that only understands single byte characters and/or varchar.
However new development should probably use nvarchar esp. since 64-bit systems are becoming the norm. Also, companies (even small ones) are now more commonly global.