Print Page | Close Window

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!    nchar did the trick.  

What threw me off was that nchar showed a maximum of 16 characters in the SQL enterprise manager. 

Thanks!!
Bob


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
 



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net