|
|||||||||
|
|||||||||
|
|||||||||
 |
|||||||||
| |
||
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
ASP Free Forums Sponsor:
|
|
|
|
#1
May 5th, 2004, 12:04 AM
|
|||
|
|||
Storing Data in MS SQL 'Text' datatype
Hi
I'm trying to store data in the mssql text datatype but it only seems to accept the first 1024 chars. I thought that this was something to do with the way it stores data of this type but even when i retrieve it through ASP it only returns 1024 chars. Can someone please tell me if I need to configure SQL differently in anyway. Should I be doing something differently in ASP that is different to the usual methods? Regards Cameron
|
|
#2
May 6th, 2004, 01:28 PM
|
|||
|
|||
|
I answered my own question!
I had been inserting the data through Enterprise Manager and it would seem that it only takes 1024 characters when doing it in this way. So...I went back to basics and used SQL update! Cameron
|
|
| Viewing: ASP Free Forums > Database > SQL Development > Storing Data in MS SQL 'Text' datatype |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
|
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
