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 |
|
spinoza
Starting Member
49 Posts |
 Posted - 2006-01-24 : 05:47:43
|
| In a field there is a very long text. I am trying to retrieving using query analyser but again it gives me only part of the document...any help please? |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2006-01-24 : 06:14:10
|
| I had a similar problem retreiving text datatypes in a web page, so i changed it to varchar, but that was ages agoIs your datatype text ? |
 |
|
|
spinoza
Starting Member
49 Posts |
Posted - 2006-01-24 : 06:37:20
|
| ntext is the datatype |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-01-24 : 06:44:27
|
| In Query Analyser, gotoTools->Options->ResultsChange the value of Maximum Characters per column to 8000MadhivananFailing to plan is Planning to fail |
|
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2006-01-24 : 06:49:38
|
| In query analyser the limit is 8000 characters per column. To Change the setting goto Tools --> Options --> Results change Maximum characters per column to 8000If the text is more then 8000 that u r trying to retrieve it will still truncate anything above 8000. |
|
|
|
harshal_in
Aged Yak Warrior
633 Posts |
Posted - 2006-01-24 : 06:50:21
|
| oops !! maddy, u r faster :) |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-01-24 : 06:56:27
|
quote:
Originally posted by harshal_in
oops !! maddy, u r faster :)
No problem. This happens to all  MadhivananFailing to plan is Planning to fail |
|
|
|
spinoza
Starting Member
49 Posts |
Posted - 2006-01-24 : 06:59:11
|
| Gracias all of them |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2006-01-24 : 08:15:15
|
| I would advice you use varchar(8000) instead of ntext |
|
|
|
|
|
|
Cant see from query analyser the text...