0

I am using SQL Server 2005 as the back - end for my application. I have given the datatype varchar(max) for a particular column but its storing only 1000 characters. Why is it like that.

Mathew Paul
  • 647
  • 3
  • 16
  • 36
  • Does SQL 2005 even support `varchar(max)`? – leppie Feb 01 '11 at 09:06
  • 1
    Yes leppie it has a datatype called Varchar(MAX), i dont have any idea whether it supports or not. – Mathew Paul Feb 01 '11 at 09:08
  • How do you know that it stores only 1000 characters?? How are you interacting with the database - Mgmt Studio? Your own app?? Could it be that your app somehow limits the size of the string to 1'000 chars?? – marc_s Feb 01 '11 at 09:15
  • @leppie Yes, it does. It was introduced to replace the text datatype, which is by now declared deprecated. – fancyPants Feb 01 '11 at 10:26

2 Answers2

3

Its support varchar(max) and it can store more than 1000 character.

I think Mathew you have given the range in insert or update query for this table.

might be in the stored procedure or query you have define the limitations.

Bhavik Goyal
  • 2,786
  • 6
  • 23
  • 42
  • 2
    Thank you Bhavik earlier in my db it was 1000 but after some days admin changed the db size to max but it was not implemented in my stored procedure any way thank you for your valuable reply – Mathew Paul Feb 01 '11 at 09:27
2

Random thought: Your intermediate datatypes/conversions are not varchar(max)

Community
  • 1
  • 1
gbn
  • 422,506
  • 82
  • 585
  • 676