Skip to Content.
Sympa Menu

freetds - Still problems with text fields?

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Don Burden <donb AT zirmed.com>
  • To: 'TDS Development Group' <freetds AT franklin.oit.unc.edu>
  • Subject: Still problems with text fields?
  • Date: Thu, 25 Jul 2002 11:24:17 -0400


Is there still a bug with length of text fields or am I doing anything
wrong?

Using yesterdays nightly build of freeTDS. Accessing SQL2000 database.
Here's my code:

.....
SQLAllocHandle(SQL_HANDLE_STMT, hdbc, &hstmt);
SQLBindCol(hstmt, 1, SQL_C_CHAR, sCol1, -1, &cbCol1);
SQLExecDirect(hstmt, "SELECT id FROM TEST", SQL_NTS);
while(SQLFetch(hstmt)==0)
fprintf(stdout, "%s\n", sCol1);
.....

Here is the TEST table:

id
======
12345
123456
1234567
123456
12345

If id field is defined as varchar, output is ok:

12345
123456
1234567
123456
12345

If id field is defined as text, output is like this:

12345
12345
1234567@
1234567@
1234567@




Archive powered by MHonArc 2.6.24.

Top of Page