Large capacity SQL database field

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
rsorrells Members Profile Find Members Posts Newbie Joined: 03 July 2006 Location: United States Status: Offline Points: 7	Post Options Post Reply Quote rsorrells Report Post Thanks(0) Quote Reply Topic: Large capacity SQL database field 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

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply 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
	Web Wiz Forums Hosting ASP.NET Web Hosting

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply 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
	Web Wiz Forums Hosting ASP.NET Web Hosting

rsorrells Members Profile Find Members Posts Newbie Joined: 03 July 2006 Location: United States Status: Offline Points: 7	Post Options Post Reply Quote rsorrells Report Post Thanks(0) Quote Reply 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

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply 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.
	Web Wiz Forums Hosting ASP.NET Web Hosting

rsorrells Members Profile Find Members Posts Newbie Joined: 03 July 2006 Location: United States Status: Offline Points: 7	Post Options Post Reply Quote rsorrells Report Post Thanks(0) Quote Reply 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

Post Reply

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum

About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.