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 |
|
griffcj
Starting Member
9 Posts |
 Posted - 2005-12-29 : 16:09:44
|
| I have a table with a varchar field with a length of 8000. I have data stored in it, but need to store larger amounts of data in that field. I need to goto datatype Text. I tried using DTS to export the information into another table and allowing it to do the datatype coversion. When I looked into the database that the data was inported into. Most of the fields where showing <Long Text>. Does that mean that the data was not inserted? If it did not insert it, can anyone point me in the right direction? I tried reading up on using BLOB's and my head started to spin. Is there an easier way?There is only 2 fields in my table. Here is how it looks now.CREATE TABLE [dbo].[tbl_contact_reports_notes4] ( [rpt4_id] [uniqueidentifier] NOT NULL , [case_summary] [varchar] (8000) COLLATE SQL_Latin1_General_CP1_CI_AS NULL )The case summary fiels is what need to be converted.Thank you in advance for any help. |
|
|
shallu1_gupta
Constraint Violating Yak Guru
394 Posts |
Posted - 2005-12-30 : 00:05:00
|
| Enterprise Manager by default shows <Long Text> if there is large text in Text fields. you can see the values in query Analyzer to get an idea |
 |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2005-12-30 : 06:00:27
|
| i would advice1. Dont use text datatype, you would run into errors. Esp if you are trying to insert into a web page. Stick to varchar(8000)2. Dont use BLOB, there are so many posts on thisIf you are using images, save the relative path in your db, and put the images in a folderHope this helps ?Afrika |
|
|
|
|
|
|
Converting From Varchar to Text