. .

    @Mail.ru -

CHAR VARCHAR MySQL.

» PHP » MySQL » CHAR VARCHAR

MySQL CHAR VARCHAR , .

CHAR . 1 255. MySQL 3.23 CHAR 0 255. CHAR , . CHAR , .

VARCHAR . , VARCHAR 1 255, CHAR. , CHAR, VARCHAR , , , . , , . ANSI SQL - .

CHAR VARCHAR, , , .

. 5.3 , CHAR(4) VARCHAR(4):

5.3. CHAR(4) VARCHAR(4)

CHAR(4) VARCHAR(4)
" " " " 4 " " 1
"ab" "ab" 4 "ab" 3
"abcd" "abcd" 4 "abcd" 5
"abcdefgh" "abcd" 4 "abcd" 5

, CHAR(4) VARCHAR(4), , CHAR .

CHAR VARCHAR , BINARY . BINARY , ( !) MySQL. BINARY , .

BINARY . , , , BINARY, , BINARY.

MySQL CHAR VARCHAR . 7.3. .