FreeTDS Development Group

[Jonathan Gordon <freetds.org AT kinobe.com>]

I'm a new user and attempting to use freebcp. I've successfully used tsql to make queries to databases on MSSQL 2000 and 2005. I have successfully used bcp from Windows machines to bulk copy to both of these servers. I've gotten to the point where I run the freebcp command and it will fail with instructive errors if I input the wrong table name, login info, or server info. However, when all of that is correct and I run freebcp I don't receive any errors but no data gets uploaded. Can anyone help me figure out what's going wrong? Ideally, my target server is MSSQL 2005, so answers for that are most appreciated. 

*** Begin Environment Description ***
SQL Server 2000: 8.00.2039      SP4     Enterprise Edition
and
SQL Server 2005: 9.00.3050.00   SP2     Standard Edition

FreeTDS version: FreeTDS 0.64
Which client library you are using: freebcp
Client OS and hardware architecture: Linux kubuntu 2.6.20-16-386 #2 Sun Sep 
23 19:47:10 UTC 2007 i686 GNU/Linux
*** End Environment Description ***

I receive the same lack of response when I set the environment variable 
TDSVER=7.0 or TDSVER=8.0. Using any other TDSVER yields:

*** Begin error message ***
Msg -100, Level 11
unrecognized msgno
*** End error message ***

Here's the command I'm running:
freebcp "mailing_analysis..MATCH_MAILING_CAMPAIGN" in 
"/usr/local/work/kinobe/head/matching/application/application-assets/anchor/input/20071031.txt.out"
  -Usa -Pxxxxxx -S192.168.15.100:1433  -f 
"/usr/local/work/kinobe/head/matching/application/application-assets/anchor/input/bcp.format"  -m 
1 -F 1

I've attached the format file and the data file (1 line) as well as the error 
log I obtained via  export TDSDUMP=/tmp/freetds.log

Please let me know what I can do to figure out what's going wrong.

Thanks,

Jonathan.


7.0
15
1       SYBCHAR       0       10      "\t"                       3     KEYCODE
2       SYBCHAR       0       30      "\t"                       4     
LAST_NAME
3       SYBCHAR       0       30      "\t"                       5     
FIRST_NAME
4       SYBCHAR       0       50      "\t"                       6     
CARE_COMPANY
5       SYBCHAR       0       50      "\t"                       7     ADDRESS
6       SYBCHAR       0       50      "\t"                       8     CITY
7       SYBCHAR       0       2       "\t"                       9     STATE
8       SYBCHAR       0       10      "\t"                       10    
ZIP_CODE
9       SYBCHAR       0       4           "\t"                       11    
ZIP_PLUS_4
10      SYBCHAR       0       100     "\t"                                    
           12    MATCH_ADDRESS
11      SYBCHAR       0       100     "\t"                                    
           13    MATCH_NAME
12      SYBCHAR       0       12      "\t"                                    
           2     CAMPAIGN_ID
13      SYBCHAR       0       12      "\t"                                    
           14    MAILING_LIST_MAILING_ID
14      SYBCHAR       0       12      "\n"                                    
           15    COUNTRY_LE_ID
15      SYBCHAR       0       0       ""                                      
           1     ID



util.c:288:Starting log file for FreeTDS 0.64
	on 2007-11-01 14:52:19 with debug flags 0x4fff.
iconv.c:195:names for ISO-8859-1: ISO-8859-1
iconv.c:195:names for UTF-8: UTF-8
iconv.c:195:names for UCS-2LE: UCS-2LE
iconv.c:195:names for UCS-2BE: UCS-2BE
iconv.c:361:iconv to convert client-side data to the "ISO-8859-1" character set
iconv.c:514:tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
iconv.c:514:tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"
net.c:168:Connecting to 192.168.15.100 port 1433.
write.c:134:tds_put_string converting 7 bytes of "kubuntu"
write.c:162:tds_put_string wrote 14 bytes
write.c:134:tds_put_string converting 2 bytes of "sa"
write.c:162:tds_put_string wrote 4 bytes
write.c:134:tds_put_string converting 7 bytes of "FreeBCP"
write.c:162:tds_put_string wrote 14 bytes
write.c:134:tds_put_string converting 14 bytes of "192.168.15.100"
write.c:162:tds_put_string wrote 28 bytes
write.c:134:tds_put_string converting 10 bytes of "DB-Library"
write.c:162:tds_put_string wrote 20 bytes
write.c:134:tds_put_string converting 10 bytes of "us_english"
write.c:162:tds_put_string wrote 20 bytes
write.c:162:tds_put_string wrote 0 bytes
token.c:310:tds_process_login_tokens()
net.c:446:Received header
0000 04 01 01 69 00 37 01 00-                        |...i.7..|

net.c:542:Received packet
0000 e3 1b 00 01 06 6d 00 61-00 73 00 74 00 65 00 72 |.....m.a .s.t.e.r|
0010 00 06 6d 00 61 00 73 00-74 00 65 00 72 00 ab 5e |..m.a.s. t.e.r..^|
0020 00 45 16 00 00 02 00 25-00 43 00 68 00 61 00 6e |.E.....% .C.h.a.n|
0030 00 67 00 65 00 64 00 20-00 64 00 61 00 74 00 61 |.g.e.d.  .d.a.t.a|
0040 00 62 00 61 00 73 00 65-00 20 00 63 00 6f 00 6e |.b.a.s.e . .c.o.n|
0050 00 74 00 65 00 78 00 74-00 20 00 74 00 6f 00 20 |.t.e.x.t . .t.o. |
0060 00 27 00 6d 00 61 00 73-00 74 00 65 00 72 00 27 |.'.m.a.s .t.e.r.'|
0070 00 2e 00 04 4b 00 41 00-4c 00 49 00 00 00 00 e3 |....K.A. L.I.....|
0080 08 00 07 05 09 04 d0 00-34 00 e3 17 00 02 0a 75 |........ 4......u|
0090 00 73 00 5f 00 65 00 6e-00 67 00 6c 00 69 00 73 |.s._.e.n .g.l.i.s|
00a0 00 68 00 00 ab 62 00 47-16 00 00 01 00 27 00 43 |.h...b.G .....'.C|
00b0 00 68 00 61 00 6e 00 67-00 65 00 64 00 20 00 6c |.h.a.n.g .e.d. .l|
00c0 00 61 00 6e 00 67 00 75-00 61 00 67 00 65 00 20 |.a.n.g.u .a.g.e. |
00d0 00 73 00 65 00 74 00 74-00 69 00 6e 00 67 00 20 |.s.e.t.t .i.n.g. |
00e0 00 74 00 6f 00 20 00 75-00 73 00 5f 00 65 00 6e |.t.o. .u .s._.e.n|
00f0 00 67 00 6c 00 69 00 73-00 68 00 2e 00 04 4b 00 |.g.l.i.s .h....K.|
0100 41 00 4c 00 49 00 00 00-00 ad 36 00 01 71 00 00 |A.L.I... ..6..q..|
0110 01 16 4d 00 69 00 63 00-72 00 6f 00 73 00 6f 00 |..M.i.c. r.o.s.o.|
0120 66 00 74 00 20 00 53 00-51 00 4c 00 20 00 53 00 |f.t. .S. Q.L. .S.|
0130 65 00 72 00 76 00 65 00-72 00 00 00 00 00 08 00 |e.r.v.e. r.......|
0140 07 f7 e3 13 00 04 04 34-00 30 00 39 00 36 00 04 |.......4 .0.9.6..|
0150 34 00 30 00 39 00 36 00-fd 00 00 00 00 00 00 00 |4.0.9.6. ........|
0160 00                     -                        |.|

token.c:314:looking for login token, got  e3(ENVCHANGE)
token.c:105:tds_process_default_tokens() marker is e3(ENVCHANGE)
read.c:179:tds_get_string: reading 12 from wire to give 6 to client.
read.c:179:tds_get_string: reading 12 from wire to give 6 to client.
token.c:314:looking for login token, got  ab(INFO)
token.c:105:tds_process_default_tokens() marker is ab(INFO)
token.c:2439:tds_process_msg() reading message from server
read.c:179:tds_get_string: reading 74 from wire to give 37 to client.
read.c:179:tds_get_string: reading 8 from wire to give 4 to client.
token.c:2501:tds_process_msg() calling client msg handler
token.c:2514:tds_process_msg() returning TDS_SUCCEED
token.c:314:looking for login token, got  e3(ENVCHANGE)
token.c:105:tds_process_default_tokens() marker is e3(ENVCHANGE)
iconv.c:514:tds_iconv_info_init: converting "ISO-8859-1"->"CP1252"
token.c:314:looking for login token, got  e3(ENVCHANGE)
token.c:105:tds_process_default_tokens() marker is e3(ENVCHANGE)
read.c:179:tds_get_string: reading 20 from wire to give 10 to client.
token.c:314:looking for login token, got  ab(INFO)
token.c:105:tds_process_default_tokens() marker is ab(INFO)
token.c:2439:tds_process_msg() reading message from server
read.c:179:tds_get_string: reading 78 from wire to give 39 to client.
read.c:179:tds_get_string: reading 8 from wire to give 4 to client.
token.c:2501:tds_process_msg() calling client msg handler
token.c:2514:tds_process_msg() returning TDS_SUCCEED
token.c:314:looking for login token, got  ad(LOGINACK)
read.c:179:tds_get_string: reading 44 from wire to give 22 to client.
token.c:314:looking for login token, got  e3(ENVCHANGE)
token.c:105:tds_process_default_tokens() marker is e3(ENVCHANGE)
read.c:179:tds_get_string: reading 8 from wire to give 4 to client.
read.c:179:tds_get_string: reading 8 from wire to give 4 to client.
token.c:2327:increasing block size from 4096 to 4096
token.c:314:looking for login token, got  fd(DONE)
token.c:105:tds_process_default_tokens() marker is fd(DONE)
token.c:2143:tds_process_end: more_results = 0
		was_cancelled = 0
		error = 0
		done_count_valid = 0
token.c:2159:tds_process_end() state set to TDS_IDLE
util.c:119:Changing query state from IDLE to IDLE
token.c:387:leaving tds_process_login_tokens() returning 1
util.c:119:Changing query state from IDLE to QUERYING
mem.c:519:tds_free_all_results()
write.c:134:tds_put_string converting 19 bytes of "set textsize 64512 "
write.c:162:tds_put_string wrote 38 bytes
util.c:119:Changing query state from QUERYING to PENDING
net.c:673:Sending packet
0000 01 01 00 2e 00 00 00 00-73 00 65 00 74 00 20 00 |........ s.e.t. .|
0010 74 00 65 00 78 00 74 00-73 00 69 00 7a 00 65 00 |t.e.x.t. s.i.z.e.|
0020 20 00 36 00 34 00 35 00-31 00 32 00 20 00       | .6.4.5. 1.2. .|

util.c:119:Changing query state from PENDING to READING
net.c:446:Received header
0000 04 01 00 11 00 37 01 00-                        |.....7..|

net.c:542:Received packet
0000 fd 00 00 be 00 00 00 00-00                      |........ .|

token.c:526:processing result tokens.  marker is  fd(DONE)
token.c:2143:tds_process_end: more_results = 0
		was_cancelled = 0
		error = 0
		done_count_valid = 0
token.c:2159:tds_process_end() state set to TDS_IDLE
util.c:119:Changing query state from READING to IDLE
util.c:119:Changing query state from IDLE to PENDING
token.c:514:tds_process_tokens() state is COMPLETED
dblib.c:907:dbcmd() bufsz = 0
dblib.c:957:in dbsqlexec()
dblib.c:5867:in dbsqlsend()
util.c:119:Changing query state from IDLE to QUERYING
mem.c:519:tds_free_all_results()
write.c:134:tds_put_string converting 17 bytes of "set textsize 4096"
write.c:162:tds_put_string wrote 34 bytes
util.c:119:Changing query state from QUERYING to PENDING
net.c:673:Sending packet
0000 01 01 00 2a 00 00 01 00-73 00 65 00 74 00 20 00 |...*.... s.e.t. .|
0010 74 00 65 00 78 00 74 00-73 00 69 00 7a 00 65 00 |t.e.x.t. s.i.z.e.|
0020 20 00 34 00 30 00 39 00-36 00                   | .4.0.9. 6.|

dblib.c:3976:in dbsqlok() 
net.c:446:Received header
0000 04 01 00 11 00 37 01 00-                        |.....7..|

net.c:542:Received packet
0000 fd 00 00 be 00 00 00 00-00                      |........ .|

dblib.c:3995:dbsqlok() marker is fd
util.c:119:Changing query state from PENDING to READING
token.c:526:processing result tokens.  marker is  fd(DONE)
token.c:2143:tds_process_end: more_results = 0
		was_cancelled = 0
		error = 0
		done_count_valid = 0
token.c:2159:tds_process_end() state set to TDS_IDLE
util.c:119:Changing query state from READING to IDLE
util.c:119:Changing query state from IDLE to PENDING
dblib.c:4042:dbsqlok() end status was success
dblib.c:1161:dbresults()
dblib.c:1161:dbresults()
mem.c:519:tds_free_all_results()
token.c:514:tds_process_tokens() state is COMPLETED
dblib.c:1196:dbresults() process_result_tokens returned result_type = 4052 retcode = 2
util.c:119:Changing query state from IDLE to QUERYING
mem.c:519:tds_free_all_results()
write.c:134:tds_put_string converting 85 bytes of "SET FMTONLY ON select * from mailing_analysis..MATCH_MAILING_CAMPAIGN SET FMTONLY OFF"
write.c:162:tds_put_string wrote 170 bytes
util.c:119:Changing query state from QUERYING to PENDING
net.c:673:Sending packet
0000 01 01 00 b2 00 00 01 00-53 00 45 00 54 00 20 00 |........ S.E.T. .|
0010 46 00 4d 00 54 00 4f 00-4e 00 4c 00 59 00 20 00 |F.M.T.O. N.L.Y. .|
0020 4f 00 4e 00 20 00 73 00-65 00 6c 00 65 00 63 00 |O.N. .s. e.l.e.c.|
0030 74 00 20 00 2a 00 20 00-66 00 72 00 6f 00 6d 00 |t. .*. . f.r.o.m.|
0040 20 00 6d 00 61 00 69 00-6c 00 69 00 6e 00 67 00 | .m.a.i. l.i.n.g.|
0050 5f 00 61 00 6e 00 61 00-6c 00 79 00 73 00 69 00 |_.a.n.a. l.y.s.i.|
0060 73 00 2e 00 2e 00 4d 00-41 00 54 00 43 00 48 00 |s.....M. A.T.C.H.|
0070 5f 00 4d 00 41 00 49 00-4c 00 49 00 4e 00 47 00 |_.M.A.I. L.I.N.G.|
0080 5f 00 43 00 41 00 4d 00-50 00 41 00 49 00 47 00 |_.C.A.M. P.A.I.G.|
0090 4e 00 20 00 53 00 45 00-54 00 20 00 46 00 4d 00 |N. .S.E. T. .F.M.|
00a0 54 00 4f 00 4e 00 4c 00-59 00 20 00 4f 00 46 00 |T.O.N.L. Y. .O.F.|
00b0 46 00                  -                        |F.|

util.c:119:Changing query state from PENDING to READING
net.c:446:Received header
0000 04 01 01 e5 00 37 01 00-                        |.....7..|

net.c:542:Received packet
0000 fd 01 00 b9 00 00 00 00-00 81 0f 00 00 00 10 00 |........ ........|
0010 38 02 49 00 44 00 00 00-09 00 26 04 0b 43 00 41 |8.I.D... ..&..C.A|
0020 00 4d 00 50 00 41 00 49-00 47 00 4e 00 5f 00 49 |.M.P.A.I .G.N._.I|
0030 00 44 00 00 00 09 00 a7-0a 00 09 04 d0 00 34 07 |.D...... ......4.|
0040 4b 00 45 00 59 00 43 00-4f 00 44 00 45 00 00 00 |K.E.Y.C. O.D.E...|
0050 09 00 a7 1e 00 09 04 d0-00 34 09 4c 00 41 00 53 |........ .4.L.A.S|
0060 00 54 00 5f 00 4e 00 41-00 4d 00 45 00 00 00 09 |.T._.N.A .M.E....|
0070 00 a7 1e 00 09 04 d0 00-34 0a 46 00 49 00 52 00 |........ 4.F.I.R.|
0080 53 00 54 00 5f 00 4e 00-41 00 4d 00 45 00 00 00 |S.T._.N. A.M.E...|
0090 09 00 a7 32 00 09 04 d0-00 34 07 43 00 4f 00 4d |...2.... .4.C.O.M|
00a0 00 50 00 41 00 4e 00 59-00 00 00 09 00 a7 32 00 |.P.A.N.Y ......2.|
00b0 09 04 d0 00 34 07 41 00-44 00 44 00 52 00 45 00 |....4.A. D.D.R.E.|
00c0 53 00 53 00 00 00 09 00-a7 32 00 09 04 d0 00 34 |S.S..... .2.....4|
00d0 04 43 00 49 00 54 00 59-00 00 00 09 00 af 02 00 |.C.I.T.Y ........|
00e0 09 04 d0 00 34 05 53 00-54 00 41 00 54 00 45 00 |....4.S. T.A.T.E.|
00f0 00 00 09 00 a7 0a 00 09-04 d0 00 34 08 5a 00 49 |........ ...4.Z.I|
0100 00 50 00 5f 00 43 00 4f-00 44 00 45 00 00 00 09 |.P._.C.O .D.E....|
0110 00 af 04 00 09 04 d0 00-34 0a 5a 00 49 00 50 00 |........ 4.Z.I.P.|
0120 5f 00 50 00 4c 00 55 00-53 00 5f 00 34 00 00 00 |_.P.L.U. S._.4...|
0130 09 00 a7 64 00 09 04 d0-00 34 0d 4d 00 41 00 54 |...d.... .4.M.A.T|
0140 00 43 00 48 00 5f 00 41-00 44 00 44 00 52 00 45 |.C.H._.A .D.D.R.E|
0150 00 53 00 53 00 00 00 09-00 a7 64 00 09 04 d0 00 |.S.S.... ..d.....|
0160 34 0a 4d 00 41 00 54 00-43 00 48 00 5f 00 4e 00 |4.M.A.T. C.H._.N.|
0170 41 00 4d 00 45 00 00 00-09 00 26 04 17 4d 00 41 |A.M.E... ..&..M.A|
0180 00 49 00 4c 00 49 00 4e-00 47 00 5f 00 4c 00 49 |.I.L.I.N .G._.L.I|
0190 00 53 00 54 00 5f 00 4d-00 41 00 49 00 4c 00 49 |.S.T._.M .A.I.L.I|
01a0 00 4e 00 47 00 5f 00 49-00 44 00 00 00 08 00 38 |.N.G._.I .D.....8|
01b0 0d 43 00 4f 00 55 00 4e-00 54 00 52 00 59 00 5f |.C.O.U.N .T.R.Y._|
01c0 00 4c 00 45 00 5f 00 49-00 44 00 fd 01 00 c1 00 |.L.E._.I .D......|
01d0 00 00 00 00 fd 00 00 ba-00 00 00 00 00          |........ .....|

token.c:526:processing result tokens.  marker is  fd(DONE)
token.c:2143:tds_process_end: more_results = 1
		was_cancelled = 0
		error = 0
		done_count_valid = 0
util.c:119:Changing query state from READING to PENDING
util.c:119:Changing query state from PENDING to READING
token.c:526:processing result tokens.  marker is  81(TDS7_RESULT)
mem.c:519:tds_free_all_results()
token.c:1472:processing TDS7 result. set current_results to tds->res_info
read.c:179:tds_get_string: reading 4 from wire to give 2 to client.
token.c:1414:tds7_get_data_info: 
	colname = ID (2 bytes)
	type = 56 (int)
	server's type = 56 (int)
	column_varint_size = 0
	column_size = 4 (4 on server)
read.c:179:tds_get_string: reading 22 from wire to give 11 to client.
token.c:1414:tds7_get_data_info: 
	colname = CAMPAIGN_ID (11 bytes)
	type = 38 (integer-null)
	server's type = 38 (integer-null)
	column_varint_size = 1
	column_size = 4 (4 on server)
token.c:3395:adjust_character_column_size:
	Server charset: CP1252
	Server column_size: 10
	Client charset: ISO-8859-1
	Client column_size: 10
read.c:179:tds_get_string: reading 14 from wire to give 7 to client.
token.c:1414:tds7_get_data_info: 
	colname = KEYCODE (7 bytes)
	type = 39 (varchar)
	server's type = 167 (xvarchar)
	column_varint_size = 2
	column_size = 10 (10 on server)
token.c:3395:adjust_character_column_size:
	Server charset: CP1252
	Server column_size: 30
	Client charset: ISO-8859-1
	Client column_size: 30
read.c:179:tds_get_string: reading 18 from wire to give 9 to client.
token.c:1414:tds7_get_data_info: 
	colname = LAST_NAME (9 bytes)
	type = 39 (varchar)
	server's type = 167 (xvarchar)
	column_varint_size = 2
	column_size = 30 (30 on server)
token.c:3395:adjust_character_column_size:
	Server charset: CP1252
	Server column_size: 30
	Client charset: ISO-8859-1
	Client column_size: 30
read.c:179:tds_get_string: reading 20 from wire to give 10 to client.
token.c:1414:tds7_get_data_info: 
	colname = FIRST_NAME (10 bytes)
	type = 39 (varchar)
	server's type = 167 (xvarchar)
	column_varint_size = 2
	column_size = 30 (30 on server)
token.c:3395:adjust_character_column_size:
	Server charset: CP1252
	Server column_size: 50
	Client charset: ISO-8859-1
	Client column_size: 50
read.c:179:tds_get_string: reading 14 from wire to give 7 to client.
token.c:1414:tds7_get_data_info: 
	colname = COMPANY (7 bytes)
	type = 39 (varchar)
	server's type = 167 (xvarchar)
	column_varint_size = 2
	column_size = 50 (50 on server)
token.c:3395:adjust_character_column_size:
	Server charset: CP1252
	Server column_size: 50
	Client charset: ISO-8859-1
	Client column_size: 50
read.c:179:tds_get_string: reading 14 from wire to give 7 to client.
token.c:1414:tds7_get_data_info: 
	colname = ADDRESS (7 bytes)
	type = 39 (varchar)
	server's type = 167 (xvarchar)
	column_varint_size = 2
	column_size = 50 (50 on server)
token.c:3395:adjust_character_column_size:
	Server charset: CP1252
	Server column_size: 50
	Client charset: ISO-8859-1
	Client column_size: 50
read.c:179:tds_get_string: reading 8 from wire to give 4 to client.
token.c:1414:tds7_get_data_info: 
	colname = CITY (4 bytes)
	type = 39 (varchar)
	server's type = 167 (xvarchar)
	column_varint_size = 2
	column_size = 50 (50 on server)
token.c:3395:adjust_character_column_size:
	Server charset: CP1252
	Server column_size: 2
	Client charset: ISO-8859-1
	Client column_size: 2
read.c:179:tds_get_string: reading 10 from wire to give 5 to client.
token.c:1414:tds7_get_data_info: 
	colname = STATE (5 bytes)
	type = 47 (char)
	server's type = 175 (xchar)
	column_varint_size = 2
	column_size = 2 (2 on server)
token.c:3395:adjust_character_column_size:
	Server charset: CP1252
	Server column_size: 10
	Client charset: ISO-8859-1
	Client column_size: 10
read.c:179:tds_get_string: reading 16 from wire to give 8 to client.
token.c:1414:tds7_get_data_info: 
	colname = ZIP_CODE (8 bytes)
	type = 39 (varchar)
	server's type = 167 (xvarchar)
	column_varint_size = 2
	column_size = 10 (10 on server)
token.c:3395:adjust_character_column_size:
	Server charset: CP1252
	Server column_size: 4
	Client charset: ISO-8859-1
	Client column_size: 4
read.c:179:tds_get_string: reading 20 from wire to give 10 to client.
token.c:1414:tds7_get_data_info: 
	colname = ZIP_PLUS_4 (10 bytes)
	type = 47 (char)
	server's type = 175 (xchar)
	column_varint_size = 2
	column_size = 4 (4 on server)
token.c:3395:adjust_character_column_size:
	Server charset: CP1252
	Server column_size: 100
	Client charset: ISO-8859-1
	Client column_size: 100
read.c:179:tds_get_string: reading 26 from wire to give 13 to client.
token.c:1414:tds7_get_data_info: 
	colname = MATCH_ADDRESS (13 bytes)
	type = 39 (varchar)
	server's type = 167 (xvarchar)
	column_varint_size = 2
	column_size = 100 (100 on server)
token.c:3395:adjust_character_column_size:
	Server charset: CP1252
	Server column_size: 100
	Client charset: ISO-8859-1
	Client column_size: 100
read.c:179:tds_get_string: reading 20 from wire to give 10 to client.
token.c:1414:tds7_get_data_info: 
	colname = MATCH_NAME (10 bytes)
	type = 39 (varchar)
	server's type = 167 (xvarchar)
	column_varint_size = 2
	column_size = 100 (100 on server)
read.c:179:tds_get_string: reading 46 from wire to give 23 to client.
token.c:1414:tds7_get_data_info: 
	colname = MAILING_LIST_MAILING_ID (23 bytes)
	type = 38 (integer-null)
	server's type = 38 (integer-null)
	column_varint_size = 1
	column_size = 4 (4 on server)
read.c:179:tds_get_string: reading 26 from wire to give 13 to client.
token.c:1414:tds7_get_data_info: 
	colname = COUNTRY_LE_ID (13 bytes)
	type = 56 (int)
	server's type = 56 (int)
	column_varint_size = 0
	column_size = 4 (4 on server)
util.c:119:Changing query state from READING to PENDING
util.c:119:Changing query state from PENDING to READING
token.c:526:processing result tokens.  marker is  fd(DONE)
token.c:2143:tds_process_end: more_results = 1
		was_cancelled = 0
		error = 0
		done_count_valid = 0
util.c:119:Changing query state from READING to PENDING
util.c:119:Changing query state from PENDING to READING
token.c:526:processing result tokens.  marker is  fd(DONE)
token.c:2143:tds_process_end: more_results = 0
		was_cancelled = 0
		error = 0
		done_count_valid = 0
token.c:2159:tds_process_end() state set to TDS_IDLE
util.c:119:Changing query state from READING to IDLE
util.c:119:Changing query state from IDLE to PENDING
token.c:514:tds_process_tokens() state is COMPLETED

D2Z607  xxxyzLASTNAME   FIRSTNAME               1234 AVE PEDRO ALBIZ ST 2     
  AGUADILLA       PR      00603           1234 AVE PEDRO ALBIZ 2  FIRSTNAME 
XXXYZLASTNAME 27      20      8