CHAR, VARCHAR and TEXT
In most cases we work with strings in MYSQL not we think about when to use one or the other data, as well here they are the basic differences.
The char type should be used to chains with a fixed-size folios eg, key plates.
That's what happens if, for example declare a char 5 and only occupy 2 spaces, as the database manager fills so you could say that 3 spaces are wasted
varchar type to use for strings whose size is variable.
The main difference between text and varchar type is that the text does not accept such default or default values.
Consider that one of the best practice is to treat Always work with non-zero values \u200b\u200b , as the database manager has to make a special process to work with these values, you save time takin apart the validation IFNULL ISNULL equivalent in sql server
0 comments:
Post a Comment