Posts: 14
Threads: 5
Joined: Sep 2011
Reputation:
0
When uploading a Word document I get:
"Data too long for column 'mimeType' at row 1
INSERT INTO tblDocumentContent (document, version, comment, date, createdBy, dir, orgFileName, fileType, mimeType) VALUES (6, 1,'v0.1', 1318582605, 3, '6/', 'MATKAOHJELMA_alustava_D2B_vesivoima_Ruotsi_2.docx', '.docx', 'application/vnd.openxmlformats-officedocument.wordprocessingml.document')"
Is the mimeType column too short in the database?
Posts: 431
Threads: 15
Joined: Oct 2010
Reputation:
0
(10-14-2011, 04:02 PM)Jukkax Wrote: When uploading a Word document I get:
"Data too long for column 'mimeType' at row 1
INSERT INTO tblDocumentContent (document, version, comment, date, createdBy, dir, orgFileName, fileType, mimeType) VALUES (6, 1,'v0.1', 1318582605, 3, '6/', 'MATKAOHJELMA_alustava_D2B_vesivoima_Ruotsi_2.docx', '.docx', 'application/vnd.openxmlformats-officedocument.wordprocessingml.document')"
Is the mimeType column too short in the database?
The mimeType field in the database is 70 chars, which is too short for your mimetype, but
are you sure your mimetype is ok?
Uwe
Posts: 14
Threads: 5
Joined: Sep 2011
Reputation:
0
10-14-2011, 09:50 PM
(This post was last modified: 10-15-2011, 11:21 PM by Jukkax.)
(10-14-2011, 08:23 PM)steinm Wrote: (10-14-2011, 04:02 PM)Jukkax Wrote: When uploading a Word document I get:
"Data too long for column 'mimeType' at row 1
INSERT INTO tblDocumentContent (document, version, comment, date, createdBy, dir, orgFileName, fileType, mimeType) VALUES (6, 1,'v0.1', 1318582605, 3, '6/', 'MATKAOHJELMA_alustava_D2B_vesivoima_Ruotsi_2.docx', '.docx', 'application/vnd.openxmlformats-officedocument.wordprocessingml.document')"
Is the mimeType column too short in the database?
The mimeType field in the database is 70 chars, which is too short for your mimetype, but
are you sure your mimetype is ok?
Uwe
Tested from three different Windows XP & 7 computers, every Office 2010 Word document failed with this error message. Haven't tested with Excel etc. yet. I guess the mimetype is announced by the application it self (MS Word in this case), so this is not something the user can fix?
If we need to expand the mimetype field in the database, what's the (non-destructive) procedure? I'm not very familiar with database manipulation/management.
EDIT: according to http://filext.com/faq/office_mime_types.php the 70 character mimetype field really is too short for todays mimetypes. I'll open up this in the bug/error forum.
|
