Is there some sort of limit involved?
-
Hello! I am reading data from sql server in a string. but no matter how kuch the data is in the sql server, i am only getting 4000 characters. Is there some sort of limit involved in it? Tried playing with SqlConnection.PacketSize, but invained! Regards, Adeel
Do rate the reply, if it helps or even if it doesnot, because it helps the members to know, what solved the issue. Thanks.
-
Hello! I am reading data from sql server in a string. but no matter how kuch the data is in the sql server, i am only getting 4000 characters. Is there some sort of limit involved in it? Tried playing with SqlConnection.PacketSize, but invained! Regards, Adeel
Do rate the reply, if it helps or even if it doesnot, because it helps the members to know, what solved the issue. Thanks.
-
Yes, the default varchar size is 4000. Use the varchar(MAX) function to retrieve anything larger.
Daniel Minnaar Lead Software Developer
-
or use the "text" - type ( make sure to read about the limitations / gains - but I guess if the text is more than 4000 characters this type is the way to go - you don't want an index on this field right ? )
Hello! Is there any way to work with i.e. read and write data more than 8000 characters? Regards, Adeel
Do rate the reply, if it helps or even if it doesnot, because it helps the members to know, what solved the issue. Thanks.
-
Hello! Is there any way to work with i.e. read and write data more than 8000 characters? Regards, Adeel
Do rate the reply, if it helps or even if it doesnot, because it helps the members to know, what solved the issue. Thanks.