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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-04-24 : 10:43:58
|
| mary writes "data returned is being truncated at 255 characters. Where/how to I increase field length on main DB server , not just query analyser?Any help, really appreciated." |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2002-04-24 : 11:08:59
|
| What database version are you using? What is the data type? If you're using varchar fields, you should be able to increase the length to much more than 255. The SQL Server Enterprise Manager is used to do these design changes, or you can write the DDL (data definition language) statements in your query analyser (assuming you've got the right access). |
 |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2002-04-24 : 11:15:59
|
| if this is occurring in Query Analyser.....do be aware that QA has a default maximum length on the DISPLAY of a column....which can be amended. This topic has come up here before.....SEARCH for QA + MAX (or variations thereof). |
|
|
|
efelito
Constraint Violating Yak Guru
478 Posts |
Posted - 2002-04-24 : 11:27:53
|
| The display length of 255 is client application specific, it is not a database setting. In QA go to Query-->Current Query Options, then change the Maximum characters per column value on the Advanced tab.Jeff BanschbachConsultant, MCDBA |
|
|
|
|
|
|
truncating varchar fields at 255 characters