cs403 GDB 2016
For more discuss and ask question
join this group
Posted By : Tahir Siddiqui(Mani)
Total Marks 5
| Starting Date | Wednesday, July 27, 2016 |
| Closing Date | Thursday, July 28, 2016 |
| Status | Open |
| Question Title | Data Types in SQL Server |
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.
IDea Solution by Tahir siddiqui(Mani)
- The column (Table) will hold a fixed-length Unicode characters like Japanese, Chinese, French, Arabic and so on characters.
Answer:
we use NCHAR because Fixed-length
Unicode string data. n defines the string length and must be
a value from 1 through 4,000. The storage size is two times nbytes. When the collation
code page uses double-byte characters, the storage size is still n bytes. Therefore,NCHAR is best for
this.
- The data stored in a column is Unicode or multilingual and is of variable length.
Answer:
NVARCHAR is used in this questions because Variable-length
Unicode string data. n defines the string length and can be a
value from 1 through 4,000. max indicates that the maximum storage
size is 2^31-1 bytes (2 GB). The storage size, in bytes, is two times the
actual length of data entered + 2 bytes.Therefore,
NVARCHAR is best for this.
Data Type Length Storage Size Max Characters Unicode
ReplyDeletechar Fixed Always n bytes 8,000 No; each character requires 1 byte
varchar Variable Actual length of entry in bytes 8,000 No; each character requires 1 byte
nchar Fixed Twice n bytes 4,000 Yes; each character requires 2 bytes
nvarchar Variable Twice actual length of entry in bytes 4,000 Yes; each character requires 2 bytes
• The column (Table) will hold a fixed-length Unicode characters like Japanese, Chinese, French, Arabic and so on characters.
ReplyDeleteAnswer:
we use NCHAR because Fixed-length Unicode string data. n defines the string length and must be a value from 1 through 4,000. The storage size is two times nbytes. When the collation code page uses double-byte characters, the storage size is still n bytes. Therefore, NCHAR is best for this.
• The data stored in a column is Unicode or multilingual and is of variable length.
Answer:
NVARCHAR is used in this questions because Variable-length Unicode string data. n defines the string length and can be a value from 1 through 4,000. max indicates that the maximum storage size is 2^31-1 bytes (2 GB). The storage size, in bytes, is two times the actual length of data entered + 2 bytes. Therefore, NVARCHAR is best for this.
mani g ap k ans bohat alg hoty hain or confusing plz batainy kon sa ans thik ha jo ap ny post kiya ya jo m ny plz today is last day reply zaror kr dena
ReplyDeleteSorry
ReplyDeleteap k kai confusion hai u can ask .