SeanHarding Posted November 21, 2011 Share Posted November 21, 2011 What format should my MySQL database be to store a multidimensional array? BIGTEXT, VARCHAR, utf8_unicode_ci? Quote Link to comment Share on other sites More sharing options...
fenway Posted November 21, 2011 Share Posted November 21, 2011 You shouldn't be storing that kind of formatted data in a row-based database. Quote Link to comment Share on other sites More sharing options...
SeanHarding Posted November 21, 2011 Author Share Posted November 21, 2011 You shouldn't be storing that kind of formatted data in a row-based database. I have waited 6 hours for that reply... thank you. I will be serialize() the information before it gets stored in the row-based database and unserialize() it when I retrieve it. Quote Link to comment Share on other sites More sharing options...
fenway Posted November 21, 2011 Share Posted November 21, 2011 Oh, that's different -- if you're simply storing it, and not querying it or updating it, then sure, nothing wrong with that! TEXT holds up to 65K -- LONGTEXT, 4GB. But if this table is going to have a lot of rows, you might want to consider breaking this out into it's own table. Quote Link to comment Share on other sites More sharing options...
SeanHarding Posted November 21, 2011 Author Share Posted November 21, 2011 Thanks fenway. I'm creating a user generated array() I think MySQL may have some issues if the site is creating allot of tables. But then again I'm having difficulties manipulating the arrays lol. Cheers Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.