Aware IM User Forums

[kklosson]

The nature of the data I am working with is causing my row size to exceed the 8k byte max row size limitation in MySQL. There's just a lot of text fields and a lot of narrative entries. 8k bytes is about 3 pages of text - I need more. MySQL will let you define column sizes that exceed the 8k limit but once you try to enter a record that exceeds the limit, it throws an error.

Any sort of database restructuring will not result in a logical presentation. I don't want to go there.

In my readings on various forums, I am learning that MSSQL also has the same row length limitation but can overcome when using VARCHAR(MAX) data types. I'm looking for some expert answers here, especially from Aware_Support if you can help. I do not know how AwareIM is data typing Plain Text attributes. I need to know if I'm essentially going to hit the same wall if I move to MSSQL from MySQL. I'm certainly willing to do it if that can solve my problem.

[aware_support]

Aware IM uses MySQL INNODB tables, which seem to have a limitation of 8K per row.

However, this limit does NOT include VARCHAR, TEXT and BLOB field types. All Aware IM attributes of the PlainText type use either VARCHAR or TEXT field types, whereas Document and Picture types use BLOB's. This means that an instance of your object should not exceed 8K not counting Plain Text, Document and Picture attributes.

This leaves numbers, dates, duration and single references (which are internally implemented as integer foreign keys).

I can't imagine an object that uses 8K worth of numbers and dates!

If you do need such an object and restructuring is out of the question you need to use a different database which doesn't have the 8K restriction. Check out SQL Server - I don't know whether it has any restrictions on this.
_________________
Aware IM Support Team

[kklosson]

Thanks for the reply. I've opted for restructuring the schema after learning more on how I can present data from other objects. I will pursue that. So this is now somewhat academic, but my BO has a little over 100 attributes. Many of them are plain text type for narrative input. But you're saying that the plain text attributes would not be counting against the 8k limit. I find otherwise because it is purely the increase of data in a plain text attribute field that presents the error.

You say plain text attributes are either VARCHAR or TEXT. What makes the distinction, size?

[aware_support]

Yes, it's the length of the attribute that you define for the PlainText attribute - if it's greater than certain value it is mapped to TEXT, otherwise VARCHAR. TEXT is definitely not counted towards this limit, otherwise everyone would be complaining about this.

If you believe MySQL documentation, VARCHAR shouldn't be counted either - your tests suggest the opposite, so maybe you shouldn't believe their documentation or maybe it's a MySQL bug (which could be fixed in some later releases - so maybe you just need to update your MySQL version)
_________________
Aware IM Support Team

[weboo]

I have this problem as well. I have around 10 plain text fields (1500 chars each) for narrative entries. I searched the web for solutions and someone suggested splitting the table into two, others said switch the engine to MyISAM. What is the effect on my application if I switch the storage engine to MyISAM?
_________________
Aware IM Version 5.3 (Build 1533)

[aware_support]

You CANNOT change the MySQL engine to MyISAM - Aware IM will not work with it. You either need to restructure your objects or try using a different database engine.
_________________
Aware IM Support Team

[weboo]

Thanks for your response. I'll restructure my objects
_________________
Aware IM Version 5.3 (Build 1533)