Dear, MT developpers.
Do you know the limit size of each MT's database table's data?
Can we write a million words in entry?
Okay, here is an answer.
Piroli, an author of "OpenMagicVox", investigated the MT's database tabel exactly.
Here is a result of his investigation at MT5.01 Japanese version.
| column | size(bytes) |
|---|---|
| MT::Asset.label | 255 |
| MT::Asset.url | 255 |
| MT::Asset.description | 65,535 |
| MT::Asset.file_path | 255 |
| MT::Asset.file_name | 255 |
| MT::Asset.file_ext | 20 |
| column | size(bytes) |
| MT::Author.name | 255 |
| MT::Author.nickname | 255 |
| MT::Author.email | 127 |
| MT::Author.url | 255 |
| MT::Author.hint | 75 |
| column | size(bytes) |
| MT::Blog.theme_id | 255 |
| MT::Blog.name | 255 |
| MT::Blog.description | 65,535 |
| MT::Blog.site_path | 255 |
| MT::Blog.site_url | 255 |
| MT::Blog.archive_url | 255 |
| MT::Blog.archive_path | 255 |
| MT::Blog.sanitize_spec | 255 |
| coulemn | size(bytes) |
| MT::Category.label | 100 |
| MT::Category.description | 65,535 |
| MT::Category.basename | 255 |
| column | size(bytes) |
| MT::Comment.author | 100 |
| MT::Comment.email | 127 |
| MT::Comment.url | 255 |
| MT::Comment.text | 65,535 |
| column | size(bytes) |
| MT::Entry.title | 255 |
| MT::Entry.excerpt | 65,535 |
| MT::Entry.text | 65,535 |
| MT::Entry.text_more | 65,535 |
| MT::Entry.to_ping_urls | 65,535 |
| MT::Entry.keywords | 65,535 |
| MT::Entry.basename | 255 |
| column | size(bytes) |
| MT::Log.message | 65,535 |
| column | size(bytes) |
| MT::Notification.name | 50 |
| MT::Notification.email | 75 |
| MT::Notification.url | 255 |
| column | size(bytes) |
| MT::PluginData.plugin | 50 |
| MT::PluginData.key | 255 |
| MT::PluginData.data | 65,535 |
| column | size(bytes) |
| MT::Role.name | 255 |
| MT::Role.description | 65,535 |
| column | size(bytes) |
| MT::Tag.name | 255 |
| column | size(bytes) |
| MT::TBPing.title | 255 |
| MT::TBPing.excerpt | 65,535 |
| MT::TBPing.source_url | 255 |
| MT::TBPing.blog_name | 255 |
| column | size(bytes) |
| MT::Template.name | 255 |
| MT::Template.outfile | 255 |
| MT::Template.text | 65,535 |
| MT::Template.linked_file | 255 |
| MT::Template.identifier' | 50 |
| column | size(bytes) |
| MT::TemplateMap.file_template | 255 |
After this article, Piroli published another entry to follow this information.
In the entry, he mentioned that some MT tabel columns, whish using “varchar”, are allowd to enter “number of characters”, not “bytes”.
Piroli is known as a MT's power user, and also a prolific plugin developer.
He created so many plugins for MT, and they are really useful.
Leave a comment