Skip to Content.
Sympa Menu

freetds - Re: [freetds] Fwd: [unixODBC-support] PHP PDO unixODBC FreeTDS SQL Server text column size

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Jochen Daum <jd AT automatem.co.nz>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] Fwd: [unixODBC-support] PHP PDO unixODBC FreeTDS SQL Server text column size
  • Date: Mon, 1 Oct 2012 10:49:05 +1300

Feedback:

>>>> am I supposed to use the HEAD of 0.91 branch or the nightly snapshot?
> http://gitorious.org/freetds/freetds

I've now done
./autogen.sh --with-tdsver=7.2
make
make install

select [Attachment].[attaFilename], [Attachment].[attaContent] from
[Attachment] WHERE ([Attachment].[attaId] = 10239)

works now, this is the minimum data I need.

However

select [Attachment].[attaId], [Attachment].[attaRefTable],
[Attachment].[attaRefKey], [Attachment].[attaHidden],
[Attachment].[attaFilename], [Attachment].[attaContent],
[Attachment].[attaAdded], [Attachment].[attaAddedBy],
[Attachment].[attaComments], [Attachment].[attaDocumentCode]
FROM [Attachment]
WHERE ([Attachment].[attaId] = 10239)

doesn't work, it outputs

Aborted (core dumped)

token.c:2304:tds_process_row(): reading column 6
token.c:2049:tds_get_data: type 111, varint size 1
token.c:2110:tds_get_data(): wire column size is 8
token.c:2304:tds_process_row(): reading column 7
token.c:2049:tds_get_data: type 39, varint size 2
token.c:2110:tds_get_data(): wire column size is 6
token.c:2304:tds_process_row(): reading column 8
token.c:2049:tds_get_data: type 39, varint size 2
token.c:2110:tds_get_data(): wire column size is 0
token.c:2304:tds_process_row(): reading column 9
token.c:2049:tds_get_data: type 39, varint size 2
token.c:2110:tds_get_data(): wire column size is 5
util.c:156:Changed query state from READING to PENDING
odbc.c:3534:odbc_process_tokens: tds_process_tokens returned 1
odbc.c:3535: result_type=4040, TDS_DONE_COUNT=10, TDS_DONE_ERROR=2
odbc.c:3605:odbc_process_tokens: returning result_type 4040
convert_tds2sql.c:164:odbc_tds2sql: src is 56 dest = 1
convert_tds2sql.c:290:odbc_tds2sql: outputting character data destlen = 10
convert_tds2sql.c:164:odbc_tds2sql: src is 167 dest = 1
convert_tds2sql.c:164:odbc_tds2sql: src is 167 dest = 1
convert_tds2sql.c:164:odbc_tds2sql: src is 48 dest = 1
convert_tds2sql.c:290:odbc_tds2sql: outputting character data destlen = 3
convert_tds2sql.c:164:odbc_tds2sql: src is 167 dest = 1
convert_tds2sql.c:164:odbc_tds2sql: src is 167 dest = 1
convert_tds2sql.c:164:odbc_tds2sql: src is 61 dest = 1
convert_tds2sql.c:290:odbc_tds2sql: outputting character data destlen = 23
convert_tds2sql.c:164:odbc_tds2sql: src is 167 dest = 1
convert_tds2sql.c:164:odbc_tds2sql: src is 167 dest = 1
convert_tds2sql.c:164:odbc_tds2sql: src is 167 dest = 1
error.c:412:odbc_errs_add: "Data truncated"
error.c:517:SQLGetDiagRec(3, 0xe9bcc0, 1, 0x7fff61c8bab0,
0x7fff61c8b684, 0x7fff61c8b8b0, 512, 0x7fff61c8b688)
error.c:566:SQLGetDiagRec: "[FreeTDS][SQL Server]Data truncated"
error.c:517:SQLGetDiagRec(3, 0xe9bcc0, 2, 0x7fff61c8bab0,
0x7fff61c8b684, 0x7fff61c8b8b0, 512, 0x7fff61c8b688)
error.c:517:SQLGetDiagRec(3, 0xe9bcc0, 1, 0x7fff61c8bc10,
0x7fff61c8b808, 0x7fff61c8b810, 1024, 0x7fff61c8b80e)
error.c:566:SQLGetDiagRec: "[FreeTDS][SQL Server]Data truncated"


Kind Regards,

Jochen







>
> Frediano
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds



--
P.S.: Latest newsletter: Website application reporting - an overview -
http://eepurl.com/pKrAD

Kind Regards,

Jochen Daum

"There is no shortcut to anywhere worth going" - Beverly Sills

Automatem Ltd
Phone: +64 9 630 3425
Mobile: +64 21 567 853
Email: jd AT automatem.co.nz
Website: www.automatem.co.nz
Skype: jochendaum
http://nz.linkedin.com/in/automatem
http://twitter.com/automatem




Archive powered by MHonArc 2.6.24.

Top of Page