Solved

string data type

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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

777 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