?
Solved

string data type

Posted on 2011-03-04
4
Medium Priority
?
401 Views
Last Modified: 2012-05-11
i am using the string data type, and wanted to see how long of characters can it hold.. but http://msdn.microsoft.com/en-us/library/ms714540%28v=vs.85%29.aspx
does not mention that data type? am i looking in the wrong place or is it a newer version? (i am using 2000)

thanks
0
Comment
Question by:anushahanna
4 Comments
 
LVL 11

Assisted Solution

by:Michael Vasilevsky
Michael Vasilevsky earned 600 total points
ID: 35037512
0
 
LVL 77

Accepted Solution

by:
peter57r earned 700 total points
ID: 35037653
But actually 2gb (:-)

I seem to recall that 64k might be the limit when entering data through the UI, but programmatically it can be as much data as will fit in the database file. (So a bit less than 2gb really)
0
 
LVL 18

Assisted Solution

by:jmoss111
jmoss111 earned 700 total points
ID: 35037659
The String data type is usually used as a variable-length type of variable. A variable-length string can contain up to approximately 2 billion characters. Each character has a value ranging from 0 to 255 based on the ASCII character set. Strings are used when Text is involved.
0
 
LVL 6

Author Comment

by:anushahanna
ID: 35041477
thanks for confirming.
0

Featured Post

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

I have had my own IT business for a very long time. I started mostly with hardware and after about a year started to notice a common theme. I had shelves with software boxes -- Peachtree, Quicken, Sage, Ouickbooks -- and yet most of my clients were…
Usually, rounding is performed by some power of 10 - to thousands, hundreds, tens, or integer - or to one, two, or more decimals. But rounding can also be done to a power of two, say, 16 or 64, or 1/32 or 1/1024, even for extreme values.
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
The Relationships Diagram is a good way to get an overall view of what a database is keeping track of. It is also where relationships are defined. A relationship specifies how two tables connect to each other. As you build tables in Microsoft Ac…

569 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question