Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

Why do column names more than 30 characters long, get chopped off at 30 characters?

characters chopped column names
0
Posted

Why do column names more than 30 characters long, get chopped off at 30 characters?

0

You are very probably using TDS 4.2 to communicate with the SQL Server. TDS 4.2 is the protocol used by SQL Server 6.5 and it has the limitations of SQL Server 6.5 (among which a maximum column name size of 30 characters). jTDS 0.2 and earlier use TDS 4.2 by default. In order to change that you have to specify it explicitly in the Properties or the URL you supply when you create the connection. If you experience this problem with versions 0.3 or later, then you have specified (in the connection properties or URL) that TDS 4.2 should be used; remove that setting. For more information about URL format and the properties that may be passed to jTDS have a look at the jTDS URL format. ^ top ^ jTDS fetches only the first 4Kb of IMAGE data. You are very probably using TDS 4.2 to communicate with the SQL Server. TDS 4.2 is the protocol used by SQL Server 6.5 and it has the limitations of SQL Server 6.5 (among which a maximum size for IMAGE data of 4Kb). jTDS 0.2 and earlier use TDS 4.2 by defa

Related Questions

What is your question?

*Sadly, we had to bring back ads too. Hopefully more targeted.