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-10-29 : 09:05:20
|
| abhishek writes "hi i am abhisheki want know that when i am using varchar with asp retriving of data is very fast but when i am using text or ntext then data retrivation is very slow i am using ntext or text because i want to insert big data through aspso kidly help me out in this problem." |
|
|
andre
Constraint Violating Yak Guru
259 Posts |
Posted - 2002-10-29 : 09:26:40
|
| Text and ntext datatypes are slower than varchar because they are not stored in tables like varchar(although I think there is a way to store text fields in a table in SQL Server 2000). I would recommend avoiding text and ntext and use varchar instead. On SQL 7 and 2000, the maximum length of a varchar field is 8000.Edited by - andre on 10/29/2002 09:28:46 |
 |
|
|
|
|
|
regarding text and ntext datatype