I am using LONGTEXT since I need to use fulltext searching which is a form of BLOB
Code: Select all
sql = "CREATE TABLE emailbodystore ( id INTEGER PRIMARY KEY,"
sql + "subject VARCHAR(200), body LONGTEXT, FULLTEXT ( subject,body) )"
sql + " ENGINE MyIsam"
SetDatabaseBlob( gODBCdb, 0, NewPtr, NewSize )
sql = "INSERT INTO emailbodystore ( id, subject, body )"
sql + " VALUES ("
sql + Str( id ) + ","
sql + "'" + EmailInfo\szSubject + "',"
sql + "? );"
UPDATE:
Actually I get an error "MySQL server has gone away"
But It certainly is not the case as I am connected to it and can do queries etc
Is there a bug? or not supported?