Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rajeshkumar77
Starting Member
46 Posts |
 Posted - 2002-04-24 : 07:08:15
|
| Dear friends,I would like to storage a large amount of text file data in database (MS SQL). please suggest me, which data type is best for this.Your kind cooperation would be greatly appreciated.thanks in advance.looking forward to hearing reply.YoursRajesh |
|
|
dsdeming
479 Posts |
Posted - 2002-04-24 : 08:07:16
|
| If the data is less that 8000 characters long, use varchar. Otherwise the 'text' datatype is what you want. |
 |
|
|
rajeshkumar77
Starting Member
46 Posts |
Posted - 2002-04-24 : 08:38:54
|
Dear dsdeming,Thank you for your reply.Now I will use 'text' data type in my table.If u have any idea about, size of the data that 'text' datatype can store in database, please share ur ideas.Thanks once again for your replyYoursRajeshquote:
If the data is less that 8000 characters long, use varchar. Otherwise the 'text' datatype is what you want.
|
|
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2002-04-24 : 09:11:32
|
| SQL Books Online (BOL) will give you precise details on this, but roughly it will be enough to store a novel!!!!......I think it's of the order of 2-3(MB or GB)..... |
|
|
|
jackstow
Posting Yak Master
160 Posts |
Posted - 2002-04-24 : 09:12:37
|
| According to the book in front of me text can store 2,147,483,647 characters and is non-Unicode , ntext can store 1,073,741,823 and is Unicode. You might want to think about storing it in smaller chunks though. If it's a book for example you could store it in chapters in seperate varchar fields. |
|
|
|
|
|
|
|
|
storing large amount of data