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?

freddiefujiwara
  • 57,041
  • 28
  • 76
  • 106

1 Answers1

1

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.

chaos
  • 122,029
  • 33
  • 303
  • 309