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 |
|
helpme
Posting Yak Master
141 Posts |
 Posted - 2005-02-06 : 10:24:06
|
| We have a table, currently in oracle, that we are trying to replicate in sql server. It has some large columns in it that are going to require text, ntext, or image data types. The columns are just text that has been keyed in. I would assume we would want to use the 'text' data type, possibly using the sp_tableoption with 'text in row' option turned on. There aren't a lot of rows in the table, but it has some very large column requirements (again, just text). If you have experience using these data types, I would appreciate hearing from you. Thanks in advance! |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-02-06 : 10:56:16
|
| What do you want to hear?If you want to hold more than 8000 chars in a column then you need to use a text datatype.Expect them to cause problems though as there are a lot of things that can't be done with text datatypes - read about it in bol and test.You can use this to generate large text columns for testing.http://www.mindsdoor.net/SQLTsql/InsertTextData.html==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
helpme
Posting Yak Master
141 Posts |
Posted - 2005-02-06 : 11:35:52
|
| Most won't be that long (> 8000), but there are some that will be in excess of 1000 chars, enough to exceed the 8060 limit. I guess the 'image' data type would primarily be used for storing GIF, JPEG or other types of images. When would you use ntext? |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-02-06 : 11:51:51
|
| ntext is for storing unicode data. If you are just ascii then text would do.Also condiser splitting the tables into two and joining on the PK to hold the long strings. In that way you will still be able to use string functions on the data.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
data type question