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? Link to comment https://forums.phpfreaks.com/topic/251534-store-multidimensional-array/ 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. Link to comment https://forums.phpfreaks.com/topic/251534-store-multidimensional-array/#findComment-1290012 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. Link to comment https://forums.phpfreaks.com/topic/251534-store-multidimensional-array/#findComment-1290020 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. Link to comment https://forums.phpfreaks.com/topic/251534-store-multidimensional-array/#findComment-1290024 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 Link to comment https://forums.phpfreaks.com/topic/251534-store-multidimensional-array/#findComment-1290042 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.