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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...