Messages posted by: leono

DDL:

create table tblLenTest ( mycol varchar (50))
GO
insert into tblLenTest(mycol) values('This is a string which is longer than 24 chars')
GO

Then, executing:
java -classpath /Users/leon/Desktop/Download/jisql/lib/jisql.jar:/Users/leon/cvs/_shared/_Java/mssql/mssqlserver.jar:/Users/leon/cvs/_shared/_Java/mssql/msbase.jar:/Users/leon/cvs/_shared/_Java/mssql/msutil.jar com.xigole.util.sql.Jisql -driver mssql -user XXX -password XXX -c \; -cstring jdbc:microsoft:sqlserver://XXX:1433;databaseName=master

and entering:
1 > select * from tblLenTest;

results in:
mycol |
-------------------------|
This is a string which i |

Driver Info:

driver.getMajorVersion() is 2
driver.getMinorVersion() is 2
driver is JDBC compliant
driver property named "netAddress"
description: "Workstation's network interface card address"
required parameter?: "false"
current value: "000000000000"

driver property named "portNumber"
description: "Port number"
required parameter?: "false"
current value: "1433"

driver property named "hostProcess"
description: "Workstation process ID number"
required parameter?: "false"
current value: "0"

driver property named "user"
description: "Login ID"
required parameter?: "true"
current value: ""

driver property named "sendStringParametersAsUnicode"
choices:
choice 0: "false"
choice 1: "true"
description: "Send UCS2 String Parameters As Unicode"
required parameter?: "false"
current value: "true"

driver property named "databaseName"
description: "Database name"
required parameter?: "false"
current value: ""

driver property named "programName"
description: "Name of the application program"
required parameter?: "false"
current value: ""

driver property named "serverName"
description: "Server name"
required parameter?: "true"
current value: ""

driver property named "selectMethod"
choices:
choice 0: "cursor"
choice 1: "direct"
description: "Select Method"
required parameter?: "false"
current value: "direct"

driver property named "WSID"
description: "Workstation's ID"
required parameter?: "false"
current value: ""

driver property named "password"
description: "Login Password"
required parameter?: "true"
current value: ""

metaData.getDatabaseProductName(): "Microsoft SQL Server"
metaData.getDatabaseProductVersion(): "Microsoft SQL Server 2000 - 8.00.760 (Intel X86)
Dec 17 2002 14:22:05
Copyright (c) 1988-2003 Microsoft Corporation
Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 1)
"
metaData.getDriverName(): "SQLServer"
metaData.getDriverVersion(): "2.2.0029"

Hi! I'm using jisql on the command line to connect to a MS SQL Server, and all of my varchar values are truncated to 24 characters. I'm using Microsoft's JDBC driver. Any ideas why this truncation might be happening?