Win a copy of The Little Book of Impediments (e-book only) this week in the Agile and Other Processes forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

MySQL does not compile CLOB datatype

 
Himai Minh
Ranch Hand
Posts: 1361
7
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic