MySQL does not compile CLOB datatype

[Himai Minh]

In chapter 10, multipleTableCompoundPrimaryKey example, there is a SQL statement like this:

CREATE TABLE EMP_LOB (COUNTRY VARCHAR(255) NOT NULL, ID INTEGER NOT NULL, PHOTO BLOB, COMMENTS CLOB,
                     PRIMARY KEY(COUNTRY,ID),
                     CONSTRAINT EMPLOYEE_FK FOREIGN KEY (COUNTRY,ID) REFERENCES EMPLOYEE (COUNTRY,EMP_ID));

In MySQL, it cannot compile CLOB datatype.
I have to modify CLOB into text as this and it compiles:

CREATE TABLE EMP_LOB (COUNTRY VARCHAR(255) NOT NULL, ID INTEGER NOT NULL, PHOTO BLOB, COMMENTS text,
                     PRIMARY KEY(COUNTRY,ID),
                     CONSTRAINT EMPLOYEE_FK FOREIGN KEY (COUNTRY,ID) REFERENCES EMPLOYEE (COUNTRY,EMP_ID));

Reference:
http://www.herongyang.com/JDBC/MySQL-CLOB-Columns-CREATE-TABLE.html