Large capacity SQL database field
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Rich Text Editor (RTE)
Forum Description: Support forum for the Web Wiz Rich Text Editor (RTE).
URL: https://forums.webwiz.net/forum_posts.asp?TID=20527
Printed Date: 29 March 2026 at 5:16am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Large capacity SQL database field
Posted By: rsorrells
Subject: Large capacity SQL database field
Date Posted: 03 July 2006 at 4:39pm
|
Hello,
I am creating a web site for an all-volunteer youth soccer club in Alabama US. I've used RTE for a really cool content management web site, so the club president can update their own content of every page. That way they won't have to bother me with every change.
The database back-end that I'm using is Microsoft SQL Server 2000, which has a variable type called varchar, that is 8000 max. This is the largest variable capacity type that I saw. I need about 5 times as much storage.
Has anyone ever run into this limit? Is there an easy way around it?
Thanks,
Bob
|
Replies:
Posted By: WebWiz-Bruce
Date Posted: 03 July 2006 at 4:55pm
|
You need to use text or ntext data type, this will give you a much larger capacity that the varchar data type. Anything over 255 characters you should try and use text or ntext and not varchar ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: WebWiz-Bruce
Date Posted: 03 July 2006 at 4:57pm
|
The following page gives more details on the datatypes used in SQL Server:- http://www.databasejournal.com/features/mssql/article.phpr/2212141 - http://www.databasejournal.com/features/mssql/article.phpr/2212141 ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: rsorrells
Date Posted: 03 July 2006 at 6:02pm
|
Thank you! What threw me off was that nchar showed a maximum of 16 characters in the SQL enterprise manager. Thanks!!
Bob
|
nchar did the trick. Posted By: WebWiz-Bruce
Date Posted: 04 July 2006 at 11:49am
|
For better performance you should use ntext or text datatype for the amounts of data that you require.
------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |
Posted By: rsorrells
Date Posted: 04 July 2006 at 12:45pm
|
Thanks for catching that. I actually did use ntext, but i must have had nchar on my mind when I made the post. The application is working great. I got the upload working. I had to set read/write/modify permissions on the "my_document" folder.
Bob
|