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: Frediano Ziglio <freddy77 AT gmail.com>
  • 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 09:02:02 +0100

2012/9/30 Jochen Daum <jd AT automatem.co.nz>:
> 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)
>

Really bad!

The easier thing is to issue these commands

# ulimit -c unlimited
# <execute your program>
# gdb <executable> <core file>
> bt full

(core file is produced by the executable when it crash). I added
another fix to bsqlodbc, it could be that you have an empty string
column ('').

Frediano

> 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
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds



  • Re: [freetds] Fwd: [unixODBC-support] PHP PDO unixODBC FreeTDS SQL Server text column size, Frediano Ziglio, 10/01/2012

Archive powered by MHonArc 2.6.24.

Top of Page