Why do column names more than 30 characters long, get chopped off at 30 characters?
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