• Post Reply Bookmark Topic Watch Topic
  • New Topic

MySQL does not compile CLOB datatype  RSS feed

 
Himai Minh
Ranch Hand
Posts: 1574
10
  • 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
 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!