Let suppose you are working as a database controller in a renowned company which has a huge database system that change recurrently. A lot of transactions, searches and DML operations are being processed daily. It is obvious that these operations facilities are being provided by different types of query languages.
Following are the two cases;
- The organization wishes to speed up its retrieval process of data from database table(s), having no Unicode characters and also demands to save hard disk space.
- The organization wishes to speed up its retrieval process of data from database table(s), having Unicode characters and also needs not to save hard disk space.
For above mentioned cases, you are asked to create columns (table) of database with suitable data types meeting to the following conditions.
- The column (Table) will hold a fixed-length Unicode characters like Japanese, Chinese, French, Arabic and so on characters.
- The data stored in a column is Unicode or multilingual and is of variable length.
Suggest the suitable Data Types, NCHAR, NVARCHAR, CHAR and VARCHAR, for the above mentioned situations with reasoning; so that the retrieval of information from the column (tables) would be fast enough.
Note: In the above scenario you only read from columns (table) and not write to columns (table).
For every situation explain your answer with suitable arguments.