Jump to content

Best Data Type To Use

Recommended Posts

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 post
Share on other sites

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 post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...