Search code examples
mysqlcharvarcharmysql4

Create table trouble in MySQL 4.1

The column which defined with char type in a create table sentence is defined as varchar() It was defined as char(8) convert to varchar (8) in desc on DB. char(1) -> char(1) on same DB

When it defined a table of the char type more than 2 bytes, to convert for varchar() is specifications in MySQL 4.1?

Solution

  • The critical number of bytes is 3, and it only happens if the table has variable-length rows in general. See the docs for full detail.