Just like @Marconi already mentioned in the documentation, you can see it as follows:
- You need only 1 bit;
- An unorthodox way of having
boolean
, with NULL
/ ' '
to false
/ true
;
- Maintainability of a legacy system where values are no longer needed, but it is impracticable to make a
DROP COLUMN
, as it could lead to a series of problems due to its lack;
This is not standard, but MySQL
allows. In the SQL SERVER
for example:
char [(n)] Non-Unicode string data of
fixed length. n defines the length of the string and
must be a value from 1 to 8,000. The storage size is n bytes.
The ISO synonym for char is characters.