Skip to Content.
Sympa Menu

freetds - 0.51 - tds7.0 text type truncate problem

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: "Julio Silva" <jsilva AT ruido-visual.pt>
  • To: freetds AT franklin.oit.unc.edu
  • Subject: 0.51 - tds7.0 text type truncate problem
  • Date: Fri, 15 Jun 2001 11:13:47 -0400


In the BUGS file:

>Reported but not confirmed
>--------------------------
>1. text values getting truncated to 255 bytes under TDS 7. (can someone
>provide more detail?)

I'm seeing this. Here is my dump. Note that the text column is column 1
which
according to the dump it is made a convert from type 37 to 49. I hope this
helps:

2001-06-15 14:57:16 inside tds_process_login_tokens()
2001-06-15 14:57:17 inside tds_process_default_tokens() marker is e3
2001-06-15 14:57:17 inside tds_process_default_tokens() marker is ab
2001-06-15 14:57:17 Msg 5701, Level 0, State 2, Server xxxxx, Line 0
Changed database context to 'master'.
2001-06-15 14:57:17 inside tds_process_default_tokens() marker is e3
2001-06-15 14:57:17 inside tds_process_default_tokens() marker is e3
2001-06-15 14:57:17 inside tds_process_default_tokens() marker is fd
2001-06-15 14:57:17 leaving tds_process_login_tokens() returning 1
2001-06-15 14:57:17 leaving ct_connect() returning 1
2001-06-15 14:57:17 inside ct_cmd_alloc()
2001-06-15 14:57:33 inside ct_command()
2001-06-15 14:57:33 inside ct_send()
Sending packet @ 2001-06-15 14:57:33
0000 01 01 00 48 00 00 00 00 73 65 6c 65 63 74 20 74 |...H....select t|
0010 6f 70 20 31 20 69 64 5f 61 72 74 69 67 6f 2c 20 |op 1 id_artigo, |
0020 6e 6f 74 69 63 69 61 20 66 72 6f 6d 20 65 75 72 |noticia from eur|
0030 6f 6e 6f 74 69 63 69 61 73 2e 64 62 6f 2e 65 6e |onoticias.dbo.en|
0040 5f 61 72 74 69 67 6f 73 |_artigos|
2001-06-15 14:57:33 inside ct_results()
2001-06-15 14:57:33 processing result tokens. marker is a0
2001-06-15 14:57:33 processing result tokens. marker is a1
2001-06-15 14:57:33 inside tds_process_default_tokens() marker is a1
2001-06-15 14:57:33 processing result tokens. marker is d1
2001-06-15 14:57:33 inside ct_res_info()
2001-06-15 14:57:33 inside ct_describe()
2001-06-15 14:57:33 inside _ct_get_client_type()
2001-06-15 14:57:33 inside ct_describe() datafmt->datatype = 15 server
type 109
2001-06-15 14:57:33 inside ct_bind()
2001-06-15 14:57:33 inside ct_bind() item = 1 datafmt->datatype = 1
2001-06-15 14:57:33 inside ct_describe()
2001-06-15 14:57:33 inside _ct_get_client_type()
2001-06-15 14:57:33 inside ct_describe() datafmt->datatype = 16 server
type 35
2001-06-15 14:57:33 inside ct_bind()
2001-06-15 14:57:33 inside ct_bind() item = 2 datafmt->datatype = 1
2001-06-15 14:57:33 inside ct_fetch()
2001-06-15 14:57:33 processing row tokens. marker is d1
2001-06-15 14:57:33 setting column 0 to NULL
2001-06-15 14:57:33 setting column 1 to NULL
2001-06-15 14:57:33 inside _ct_bind_data()
2001-06-15 14:57:33 inside _ct_get_server_type()
2001-06-15 14:57:33 inside _ct_bind_data() converting column 0 from type
109 to type 47
2001-06-15 14:57:33 inside _ct_bind_data() setting source length for 0 = 8
2001-06-15 14:57:33 inside _ct_bind_data() conversion done len = 3 bindfmt
= 1
2001-06-15 14:57:33 inside _ct_bind_data() length binding len = 3
2001-06-15 14:57:33 inside _ct_get_server_type()
2001-06-15 14:57:33 inside _ct_bind_data() converting column 1 from type
35 to type 47
2001-06-15 14:57:33 inside _ct_bind_data() setting source length for 1 =
1744
2001-06-15 14:57:33 inside _ct_bind_data() conversion done len = 255
bindfmt = 1
2001-06-15 14:57:33 inside _ct_bind_data() length binding len = 255
2001-06-15 14:57:33 inside ct_fetch()
2001-06-15 14:57:33 processing row tokens. marker is fd
2001-06-15 14:57:33 inside ct_results()
2001-06-15 14:57:33 inside ct_cancel()
2001-06-15 14:57:33 inside ct_results()


Any hint? I'm thinking of moving into the source and try to fix this, what
do
you think? A tricky one or simple one?
See you,
JS




Archive powered by MHonArc 2.6.24.

Top of Page