0

What is the difference between VARCHAR2 AND CHAR datatypes?

7th Nov 2016, 6:44 AM
Ashish Vala
Ashish Vala - avatar
2 Réponses
+ 3
char Used to store character string value of fixed value. The maximum no. of characters the data type can hold is 255 characters. It's more faster than varchar. varchar Used to store variable size alphanumeric data. The maximum this data type can hold is up to In MySQL 5.0.3+: 65535 characters shared for the row. It's slower than CHAR.
7th Nov 2016, 7:44 AM
Aditya kumar pandey
Aditya kumar pandey - avatar
- 1
In my opinion, fixed length of data is MORE prefered in RDBMS, excepts altering column data length. Var data type column does not fit indexed column and frequently updated column.
20th Nov 2016, 5:44 PM
iw.song
iw.song - avatar