When I run SHOW FULL COLUMNS, it shows the Type column in lower case, such as text and varchar(255). I thought these type names were supposed to be upper case (TEXT and VARCHAR), per https://dev.mysql.com/doc/refman/8.0/en/string-types.html.

1 Answer 1


I suggest it is sloppiness on the part of the implementor.

Keywords are not case sensitive. A common convention, except by some SHOW commands, is to use uppercase.

Column names are not case sensitive.

Table and database names may be case sensitive, primarily dependent on the OS.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.