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 |
|
anundsson
Starting Member
8 Posts |
 Posted - 2006-06-19 : 11:07:05
|
| Hi!I have problem with the maximum size the text data type.The text inserted into the database gets truncated at 65000 characters.I have triedSET TEXTSIZE 1000000but without any results.Could someone please tell me how to expand the capacity of the column.Thanks! |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-06-19 : 12:15:51
|
| Max sixe of text datatype is 2,147,483,647.I doubt if that's your problem.More likely you method of population or viewing is doing the truncation.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
sqldev80
Yak Posting Veteran
68 Posts |
Posted - 2006-06-19 : 13:17:59
|
| 2^31 - 1 |
|
|
|
sqldev80
Yak Posting Veteran
68 Posts |
Posted - 2006-06-19 : 13:19:11
|
| can u post ur querymaybe data is truncated coz of some other problem |
|
|
|
anundsson
Starting Member
8 Posts |
Posted - 2006-06-20 : 03:28:01
|
| Thanks for your replies.I found out, after some testing, that the problem only existed in a php-application. The query worked fine in .net .It turned out that you had to set the mssql.textlimit and mssql.textsize values higher in php.ini .It solved the problem for me. |
|
|
|
|
|
|
Maximum size of text.