|
| |
| 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 |
