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 |
|
asifbhura
Posting Yak Master
165 Posts |
 Posted - 2006-07-15 : 03:41:06
|
| DearI am using varchar data type in my table.it provides maximum 8000 character. but i want more than that.how to increase size more than 8000please help me outWaiting for replyRegards,ASIF |
|
|
karuna
Aged Yak Warrior
582 Posts |
Posted - 2006-07-15 : 04:03:44
|
| Then probably you may need to use text or ntextWhat version of sql serevr you are using?ThanksKarunakaran |
 |
|
|
asifbhura
Posting Yak Master
165 Posts |
Posted - 2006-07-15 : 05:18:51
|
| DearI am using sql server 2000 |
|
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-07-15 : 06:30:04
|
| In SQL 2000, In the max size the varchar is 8000, you can not increase more then that. Alternative is the Text Datatype, but there are lots of limitation on it, Read on Book online, before implementing it.Chirag |
|
|
|
DMWCincy
Starting Member
11 Posts |
Posted - 2006-07-16 : 01:02:39
|
| Also to add to what the other two are saying, stay away from ntext if you don't need unicode text. It will store extra characters and add to the size of you data. |
|
|
|
|
|
|
how to increase size of datatype...