views:

35

answers:

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?

+1  A: 

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
Tahnk you for your answer!
ffffff