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 |
|
Pinto
Aged Yak Warrior
590 Posts |
 Posted - 2006-01-24 : 05:23:21
|
| I have a field in my sql table set to varchar and 8000 characters. However, when to try to type directly into the field in Enterprise Manager it won't let me enter anywhere near that amount of text. It is a field that will hold help text so I need it to be large. |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-01-24 : 05:48:07
|
| varchar(8000) can hold up to maximum of 8000 characters. EM might have a limit for data entry. Use your front end app to do it.----------------------------------'KH'I do work from home but I don't do homework |
 |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2006-01-24 : 06:17:10
|
| True,or run an insert in EM |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-01-24 : 06:39:39
|
| Dont use Enterprise Manager to insert data. Use Query Analyser, Front End application, DTS or bcpMadhivananFailing to plan is Planning to fail |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-01-24 : 08:45:15
|
| Apart from the EM issue, note that there is a finite limit on the table row - so 8,000 characters in one column will not be possible if, collectively, there is too much data in the other columns in the row.Kristen |
|
|
|
|
|
|
varchar and 8000 characters