I am a beginer.Help me

aligatojohn

I am using VS 2005 and SQL Server 2000. I want to store a huge of text in a field of my database.I have used ntext type but it's not large enough. Can anybody help me. Thanks

Paddy Boyd

How big are the text fields that you are storing? ntext's length is 2^31 - 1 characters... You must have a whopping server... but anyway, i believe that is the largest data type field available in sql server. Can you maybe store the text in .txt files on a server and then store the link to them in the DB?

Tarakeshwar Reddy

char - Fixed-length non-Unicode character data with a maximum length of 8,000 characters. varchar - Variable-length non-Unicode data with a maximum of 8,000 characters. text - Variable-length non-Unicode data with a maximum length of 2^31 - 1 (2,147,483,647) characters. nchar - Fixed-length Unicode data with a maximum length of 4,000 characters. nvarchar - Variable-length Unicode data with a maximum length of 4,000 characters. sysname is a system-supplied user-defined data type that is functionally equivalent to nvarchar(128) and is used to reference database object names. ntext - Variable-length Unicode data with a maximum length of 2^30 - 1 (1,073,741,823) characters.

Tarakeshwar MCP, CCIE Q(R&S) Before you criticize someone, you should walk a mile in their shoes. That way, when you criticize them, you're a mile away and you have their shoes. !sgub evah t'nseod margorP sihT ?sgub naem ayaddahW

Colin Angus Mackay

ali33 wrote:

I have used ntext type but it's not large enough.

You can store 2Gb of unicode text (~1 billion characters) in an ntext column - do you really have files greater than 2Gb?

Scottish Developers events: * .NET debugging, tracing and instrumentation by Duncan Edwards Jones and Code Coverage in .NET by Craig Murphy * Developer Day Scotland: are you interested in speaking or attending? My: Website | Blog

aligatojohn

sorry if the question is stupid:doh: When I store the content of an article in SQL Server ,I only insert a half of it and I can type anymore.I don't know how ->post question.Anyone who know about my problem can help me?Thanks.