Variable Length More Than 8000 Chars

Question

my variable length is exceeding 8000 characters. as we can't use text data type with a local variable and max limit for varchar data type is 8000 so what is the soln for that.

thanks,

Need a bit more info about what you are trying to do. But a start would be ReadText and WriteText. Warning it's quite painful. Personally I'd have a serious think about finding something else to do the work. — Tony Hopkinson, Oct 01 '13 at 10:21

score 2 · Answer 1 · edited Oct 01 '13 at 10:25

2

Use VARCHAR(MAX). It stores a maximum of 2 147 483 647 characters.

edited Oct 01 '13 at 10:25

huMpty duMpty

14,346
14
60
99

answered Oct 01 '13 at 10:20

GriGrim

2,891
1
19
33

More than that even, for a [variable](http://stackoverflow.com/questions/7611394/maximum-size-of-a-varcharmax-variable) – Damien_The_Unbeliever Oct 01 '13 at 10:26
True. Thanks for interesting research. – GriGrim Oct 01 '13 at 10:33

score 0 · Answer 2 · edited Oct 01 '13 at 10:44

0

you can use varchar(max) data type

edited Oct 01 '13 at 10:44

tomsv

7,207
6
55
88

answered Oct 01 '13 at 10:22

K T

169
1
4
14

score 0 · Answer 3 · answered Oct 01 '13 at 10:23

0

You can use nvarchar(max) data type.

answered Oct 01 '13 at 10:23

Amit

15,217
8
46
68

score 0 · Answer 4 · answered Oct 01 '13 at 10:27

0

You can use VARCHAR(MAX) or TEXT datatypes.But I prefer using VARCHAR(MAX) as TEXT datatype is deprecated.

answered Oct 01 '13 at 10:27

Heshitha Hettihewa

368
3
10

score 0 · Answer 5 · answered Oct 01 '13 at 10:49

0

If it is not text that you want to store, use

varbinary(max)

answered Oct 01 '13 at 10:49

tomsv

7,207
6
55
88

Variable Length More Than 8000 Chars

5 Answers5