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 - 2004-06-24 : 07:24:53
|
| Colin writes "When using the varchar data type I appear to be limited to a maximum of 1020 characters - no matter what the length is set to. Am I being dumb?Thanks" |
|
|
ditch
Master Smack Fu Yak Hacker
1466 Posts |
Posted - 2004-06-24 : 07:30:08
|
| If you are running your query in Query Analyzer then it might be that you have set the maximum characters per column to 1020.You can change this property by selecting Tools/Options/Results then changing the property and clicking OKDuane. |
 |
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2004-06-24 : 08:56:17
|
| Duane's right, but once you get past that, SQL has a limit of 8,000 chars in a single VARCHAR. |
|
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2004-06-24 : 09:57:05
|
| You could use text instead but Text has some limitations that make it undesirable. Especially when grouping data.JimUsers <> Logic |
|
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2004-06-24 : 10:49:36
|
| I did this one already...We proved to you that it was the application layer that was the problem...No MiraclesBrett8-) |
|
|
|
|
|
|
varchar character limitation