SurveyMojo - Field Data Storage Quiz

Join SurveyMojo Login Create/Edit Surveys Member's Area Recent Surveys Popular Surveys Active Surveys Messages

Other Sites

List by Category

Field Data Storage Quiz

Interesting notes on data storage in MySQL.

This survey has been taken 47 times



How much space does a char(20) field require minimum?
1 byte	4.3%
2 bytes	8.5%
4 bytes	8.5%
8 bytes	8.5%
20 bytes	31.9%
21 bytes	4.3%
22 bytes	2.1%
24 bytes	17.0%
Other View Answers	8.5%

How much space does a varchar(20) field require minimum?
1 byte	14.9%
2 bytes	4.3%
4 bytes	8.5%
8 bytes	12.8%
20 bytes	31.9%
21 bytes	6.4%
22 bytes	0.0%
24 bytes	8.5%
Other View Answers	6.4%

Are you surprised to know that char(20) requires 20 bytes minimum, regardless of field content?
Yes	29.8%
No	31.9%
Don't Know	31.9%

Are you surprised to know that varchar(20) requires only 1 byte minimum if there is no data for that field?
Yes	38.3%
No	27.7%
Don't Know	27.7%

True or False: char() and varchar() both have max storage values of 255 bytes?
Yes	19.1%
No	27.7%
Don't Know	46.8%

True or False: The documentation at dev.mysql.com explains why char() is better to use than varchar()
True	29.8%
False	19.1%
Don't Know	44.7%

Are you surprised to know that varchar() is actually capable of storing over 65kb of data, and char is limited to 255b?
Yes	29.8%
No	29.8%
Don't Know	34.0%

How does this knowledge make you feel about database storage and the decisions behind field type selection?
View Answers

Here are some other surveys you may be interested in:

Good Food
This survey will tell us what people like and what their food standards are.

The first Farm Animal survey
Take this survey about farm animals, you just may learn something about yourself.

Clinton vs. Obama
Find out who of these candidate hopefuls have a better chance for '08.

Comments?

Please feel free to Send us a message if you have any questions, comments, confusion, or concerns. We're still building, and we appreciate your input!

Help Center

Get Help for This Page
Contact Tech Support