Problems WIth Varchar 8000 Help please
-
Hi my name is Ritesh.
In my table I am using varchar 8000 and have set this is design view. I am typing in some text in this field but cannot type more than 1023 or there abouts. Why is that ?
I thought varchar 8000 lets you type in upto 8000 characters.
Help!!
Regards
Ritesh
-
What tool are you using to enter the information?
AN INSERT or UPDATE statement will allow the full 8,000 however I think there is a limit on the datagrid used by Enterprise Manager in SQL 7/2000.
-
Not a very good design is it. Thank you for your help
ritesh
-
Yes - the limit in EM is 1024..but no one really uses EM for data modifications..
**ASCII stupid question, get a stupid ANSI !!!** -
Not least because the blasted thing locks records blocking other processes as a result
-
If I could count the # of ways EM becomes a "blasted thing" I'd soon run out of fingers and toes...
**ASCII stupid question, get a stupid ANSI !!!** -
Depending upon how much of this you have to do you may well want to find a better interface, that being said you might try using your Sql Query Analyzer for the task instead of Enterprise Manager.
use a procedure such as:
update TableX
set
FieldX='lllllllllllllllllloooooooooooooottttttttttttttttttsssssss oooooooooofffffffffff ttttttttttttteeeeeeexxxxxttttttt'
where
TableNdx=NDX
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply