text More than 8000 chracters?
-
I need a column of text more than 8000 characters? How do I do this? What field Data Type shoud I use?
Thank you
Jen
-
Use the TEXT data type. See 'text data type' in BookonLine.
Greg
Greg
-
right on.
Thank you!
-
A word of caution here:
If you plan to modify in anyway that data try to see if you really need more than 8000 because you can learn the hard way how unfriendly text datatype tend to be
* Noel -
May be this needs another topic. I am just wondering since the row size is 8060. What is the point in having a column with 8000 unless it is a one one related to another table.
What would be the best design to have a schema within 8060 or or schema more than 8060 and have some checks, constraints for inserting the row size.
Regards,
gova -
May be this needs another topic. I am just wondering since the row size is 8060. What is the point in having a column with 8000 unless it is a one one related to another table.
Have a look at syscomments is a classical example on the use of columns with such lengths
* Noel -
You will want to look at the following...
http://www.sqlservercentral.com/columnists/rmarda/handlingthetextdatatype_printversion.asp
This is how I learned the ins-and-outs of creating, updating, reading the text data types.
-
Never said that they cannot be updated but When you get used to SET BASED manipulations and you come across all thoses digusting method that prevent trigger firing concatenation is painful and joins or searches are as cumbersome as the rest You really need to think more than once, twice, three times a lady ... wait a minute that last bit I got side tracked
Just make sure you can't do it differently
* Noel -
I wrote a software to do search in my code (vb and sql). I found out it was less trouble to send the code in chunks of 4000 characters and splitting on the return (vbcrlf, and because of the way I needed to search the code) than to use the the text datatype and trying to work with it.
-
Like I said there is always more than one way to skin a cat
* Noel -
Yup, but in that case it was a lot less trouble...
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply