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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-07-04 : 11:50:41
|
| vijay writes "Hi, In a particular table for my project I need to enter description. Sometimes the text that is entered into description exceeds more than 2000 characters. While creating the table I gave the datatype for description as TEXT and did not mentioned the size. But when I saved the table it is taking only as 16 as default. I entered the data. It is showing error. So could anyone please tell me as how to use this datatype in the front-end. My front-end is ASP and SQLServer 6.5 is my database. I hope I will get an immediate response from you people. regards vijay " |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2002-07-04 : 11:57:41
|
| TEXT is a SPECIAL datatype in SQL. If you look up BOl, you will see that the size of 16, refer to the storage of an 'address' in the database where the real value of the TEXT column is saved.To use (update, etc) TEXT fields, you have to use special keywords....one of which (I think) is UPDATETEXT.to solve your problem fully.....post the SQL statement (and if possible the DDL of the table into which the information is being saved).....you should be more successful in your search then. |
 |
|
|
|
|
|
TEXT datatype