Solved

string data type

Posted on 2011-03-04
4
328 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 10

Assisted Solution

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

Accepted Solution

by:
peter57r earned 175 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 175 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

Backup Your Microsoft Windows Server®

Backup all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Join & Write a Comment

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

760 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now