all groups > sql server data warehouse > september 2003 >
You're in the

sql server data warehouse

group:

Text Datatype


Text Datatype Meir Simcha Kogan
9/16/2003 8:19:15 AM
sql server data warehouse:
I have an access application with a form containing a text box bound to a
field in sql server of the "NText" datatype.

When the text exceeds a certain very large amount of content (over 130,000
characters) I get an error when adding text to the text box "Text is Too
Long to be Edited".

It seems that MSAcess has its own built in limit that may not be taking into
account the much larger limit of a sql text type field... or does the text
type field have a limit?

--
Meir Simcha Kogan
Chabad.org Development Team

Re: Text Datatype Jacco Schalkwijk
9/16/2003 2:55:04 PM
The maximum size of the ntext datatype in SQL Server is 2GB, or
1,073,741,823 characters. It looks like you have run into a limit of Access.

--
Jacco Schalkwijk MCDBA, MCSD, MCSE
Database Administrator
Eurostop Ltd.


[quoted text, click to view]

AddThis Social Bookmark Button