I am a newbie with Magento and am having trouble setting up a store and using Attributes. I've created an Attribute of "Compatible Models" to select which "models" each product in my store can work with / fit on. I have 92 different "models" in this Attribute for a product to possibly fit and while most only fit 10-15 models, there are some universal products that essentially can fit every "model." I've tried to select all 92 "models" in this Attribute and Save the product but each time it only selects some - but not all. In my case, it's 51 of the 92. I've found some solutions that make me think this is a database issue due to the total # of characters when you combine all of the 92 "models" being too large for a query but cannot be sure.
I came across this solution which seemed to semi-work but not really solve my issue. Instead it just created another issue:
I just tried changing the attribute from "varchar" to "text" and it seemed to work however now these mapped attributes are not showing up in the Layered Navigation nor with my Attribute Splash Page extension which creates unique pages based on a selected Attribute option. While this solution seems to allow the individual product to display all of selected Attributes in the "Additional" tab of the individual product - it does not seem to allow for the filtering, sorting, etc by using the Attribute after changing from "varchar" to "text."
Any update on how I could accomplish this? I managed to get my Product to select up to 92 "models" using my Compatible Model Attribute before switching over the entity from "varchar" to "text" -- Is this due to some sort of MySQL database limit? I honestly need to use the Attributes for Filtering more than I need them to display in the "Additional" tab of the individual product.