ProblemHelpPlease Posted November 26, 2011 Share Posted November 26, 2011 I need to know the best data type to use to store a potentially large amount of data in a single field on a single row.It is in the format 12345678912->999->999.99-> This is one string, with additional strings being combined to look like 12345678912->999->999.99->12345678912->999->999.99->12345678912->999->999.99-> I could have anything from 1 string to several thousand strings worth of data stored in the same field. I previously used varchar(5000) as the combined string would never exceed 5000 characters in length but this has now changed and the string when multiplied just 2000 times results in a string 52000 characters in length. Is it possble to store this amount of data in a single field, and what problems might I have when trying to store/access/update it. Link to comment Share on other sites More sharing options...
justsomeguy Posted November 27, 2011 Share Posted November 27, 2011 For ASCII data, there are several sizes of text fields. For binary data, they are blob fields instead of text fields. This page lists the various storage requirements. A longtext or longblob field can store 4GB. http://dev.mysql.com/doc/refman/5.0/en/storage-requirements.html Link to comment Share on other sites More sharing options...
Synook Posted November 27, 2011 Share Posted November 27, 2011 Why don't you create an additional one-to-many relation? Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.