MySQL does not recognise LONGVARBINARY

[jnioche]

The following SQL query is used for creating a table in NutchBase :

CREATE TABLE webpages (id VARCHAR(512) PRIMARY KEY,headers LONGVARBINARY,text VARCHAR(32000),status INTEGER,markers LONGVARBINARY,parseStatus LONGVARBINARY,modifiedTime BIGINT,score FLOAT,typ VARCHAR(32),baseUrl VARCHAR(512),content LONGVARBINARY,title VARCHAR(512),reprUrl VARCHAR(512),fetchInterval INTEGER,prevFetchTime BIGINT,inlinks LONGVARBINARY,prevSignature LONGVARBINARY,outlinks LONGVARBINARY,fetchTime BIGINT,retriesSinceFetch INTEGER,protocolStatus LONGVARBINARY,signature LONGVARBINARY,metadata LONGVARBINARY)

Unfortunately LONGVARBINARY is not recognised by mysql but 'LONG VARBINARY' is.

[dogacan]

I only did this temporarily because I couldn't get BLOBs to work with hsqldb. Enis reverted my commit so these will be BLOBs again.

Normally, we do not map anything to LONGVARBINARY's (we map to BLOBs) but I am keeping this issue open for now, so in the future if we ever do map to LONGVARBINARYs, we do it right.