April 26, 2002 at 12:22 pm
I've pretty much had the job of the SQL admin just dumped in my lap recently and I admit that I know very little about it...and I have a real mind tickler I'd like to clear up.
I made a table that has a very large varchar (8000) datatype column followed by a column that needs more dataspace, so I made it "text". This results in errors galore on my site. I am assuming this is a no no because (possibly) one datatype is binary and another is ASCII? Is there a way around this? Should I just create another table for the Text data and join it with the other?
thank you for your help
April 26, 2002 at 1:10 pm
The TEXT data type actualy hold a pointer to a binary file on your server, not the data itself in the column.
We have special 'text' tables with several Varchar fields to hold information that we know will be more than 8000, and link the record in the main table to this "special" text table. Actually, each table that requires to have "text" type info has it's own "text table".
April 26, 2002 at 2:06 pm
Generally columns of 8000 chars should be text columns, I'd say probably anything over 2000 even. SQL2K has the text in row option to offset the penalty you pay for using text columns.
Andy
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply