Question

wjat is the difference between CHAR AND VARCHAR data type​. pls ans fast exam

Answer 1

CHAR always uses the same amountof storage space per entry, whileVARCHAR only uses the amount necessary to store the actual text. Thechar is a fixed-length character data type, the varchar is a variable-length character data type

Answer 2

Answer:

Difference between CHAR and VARCHAR data types.

Explanation:

CHAR:-

1) A datatype available in the SQL  that helps to store the character.

2) Char denotes 'character

3) It stores value in fixed-length

4) 255 characters is the maximum length.

5) Static memory allocation is used in the case of char data type.

6) It can be used when the size of the program is consistent

VARCHAR:-

1) A datatype available in the SQL that helps to store the variable character.

2) Varchar denotes ' variable character'.

3) Store value variable length with 1 byte or 2-byte length prefix.

4) 65535 is the maximum length.

5) Dynamic memory allocation is used in the case of varchar datatype.

6) It can be used when the size of the program changes considerably