SQL Text Datatype

Wrox Programmer Forums

		Wrox Programmer Forums > ASP.NET and ASP > ASP.NET 1.0 and 1.1 > ASP.NET 1.0 and 1.1 Professional
SQL Text Datatype

ASP.NET 1.0 and 1.1 Professional For advanced ASP.NET 1.x coders. Beginning-level questions will be redirected to other forums. NOT for "classic" ASP 3 or the newer ASP.NET 2.0 and 3.5

Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 1.0 and 1.1 Professional section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com

Old

March 25th, 2006, 07:54 PM

bekim

bekim is offline

Friend of Wrox

Join Date: Jun 2004

Posts: 245

Thanks: 0

Thanked 0 Times in 0 Posts

Default

SQL Text Datatype

Hello
I have text that exceeds 8000. I tried to use Text datatype in SQL. However even when I am executing Stored Procedure with Text datatype, it only allows 8000 characters like Varchar.
Do I need to cast this somehow?
Help.

Old

March 26th, 2006, 07:16 PM

jbenson001 jbenson001 is offline

jbenson001 is offline

Friend of Wrox

Join Date: Nov 2003

Posts: 1,348

Thanks: 0

Thanked 5 Times in 5 Posts

Default

check in the sql forums

Old

March 28th, 2006, 12:05 AM

dparsons

dparsons is offline

Wrox Author

Join Date: Oct 2005

Posts: 4,104

Thanks: 1

Thanked 64 Times in 64 Posts

Send a message via AIM to dparsons

Default

use NVarChar.

"The one language all programmers understand is profanity."

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Convert datatype Text to image	roopaksr	ADO.NET	2	September 6th, 2008 03:02 PM
Problem converting datatype text to varchar	kwilliams	SQL Server 2000	4	August 15th, 2008 07:59 AM
datatype of sql	MunishBhatia	SQL Server 2005	4	January 5th, 2007 10:22 PM
Sql servere datatype	monika.vasvani	SQL Server 2000	2	December 14th, 2006 03:11 PM
SQL Datatype	rain_uk	SQL Server ASP	2	July 5th, 2005 01:34 AM