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 |
|
masiyax
Starting Member
1 Post |
 Posted - 2010-01-27 : 04:32:42
|
| Good day guys could anybody help me,I have created a table in sql using the wizard and I have a column named details that must accept 3000 characters.I developed an application and I am able to read and write data to this table but I am unable to read and write to the table when I have entered 3000 characters in my application.could anybody advise |
|
|
Kristen
Test
22859 Posts |
Posted - 2010-01-27 : 04:45:40
|
| Are you getting an error message?If no error, and you are looking at the data in SSMS (Console) then I think that only displays 255 characters (unless you change the Config - but I think the max is 8,000) |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2010-01-27 : 06:25:24
|
| In case you have doubt write this queryselect col,len(col) from your_tableMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
SQL data type