FreeTDS Development Group

["Paparo, Joshua" <Joshua.Paparo AT bankofamerica.com>]

Hi,

 

I am using freetds-0.63RC5 (version 8.0) on GNU Linux 2.4.20 to connect to 
SQLServer2000.

 

I'm having some trouble with SYBCHAR and SYBVARCHAR parameters to stored 
procs and getting an error message about charset conversion even though the 
characters used are just plain alpha. 

 

I've tried using client charsets of ISO-8859-1 and UTF-8 and have included a 
TDSDUMP below.

 

Thanks,

 

Josh Paparo

 

09:50:38.638932 Starting log file for FreeTDS 0.63RC5

      on 2004-12-17 09:50:38 with debug level 99.

09:50:38.638986 iconv to convert client-side data to the "ISO-8859-1" 
character set

09:50:38.639039 tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"

09:50:38.639082 tds_iconv_info_init: converting "ISO-8859-1"->"UCS-2LE"

09:50:38.639099 Connecting to 165.47.61.246 port 1433, TDS 8.0.

09:50:38.639405 tds_put_string converting 8 bytes of "lonlsd04"

09:50:38.639421 tds_put_string wrote 16 bytes

09:50:38.639429 tds_put_string converting 7 bytes of "pdt_dbo"

09:50:38.639437 tds_put_string wrote 14 bytes

09:50:38.639444 tds_put_string wrote 0 bytes

09:50:38.639451 tds_put_string converting 11 bytes of "EMALONMSQ10"

09:50:38.639459 tds_put_string wrote 22 bytes

09:50:38.639466 tds_put_string converting 10 bytes of "DB-Library"

09:50:38.639474 tds_put_string wrote 20 bytes

09:50:38.639481 tds_put_string converting 10 bytes of "us_english"

09:50:38.639489 tds_put_string wrote 20 bytes

09:50:38.639495 tds_put_string wrote 0 bytes

09:50:38.639529 tds_process_login_tokens()

09:50:38.641322 Received header

0000 04 01 01 85 00 34 01 00-                        |.....4..|

 

-----------------------------------------------------------------------------

 

 

 

09:50:45.087499 tds_process_end() state set to TDS_IDLE

09:50:45.087624 dbrpcinit() added rpcname "dbo.pdtReadIssuers"

09:50:45.087696 dbrpcparam() added parameter "@ccy"

09:50:45.087744 dbrpcparam() added parameter "@iss"

09:50:45.087809 dbrpcparam() added parameter "@pricingDate"

09:50:45.087855 dbrpcparam() added parameter "@label"

09:50:45.087870 dbrpcsend()

09:50:45.087883 parm_info_alloc(): parameter null-ness = 0

09:50:45.087895 param_row_alloc, size = 3, offset = 4, row_size = 4

09:50:45.087903 param_row_alloc(): doing data from value

09:50:45.087910 param_row_alloc(): copying 3 bytes of data to parameter #0

09:50:45.087922 parm_info_alloc(): parameter null-ness = 0

09:50:45.087930 param_row_alloc, size = 10, offset = 4, row_size = 4

09:50:45.087938 param_row_alloc(): doing data from value

09:50:45.087945 param_row_alloc(): copying 10 bytes of data to parameter #1

09:50:45.087954 parm_info_alloc(): parameter null-ness = 0

09:50:45.087963 param_row_alloc, size = 8, offset = 4, row_size = 12

09:50:45.087970 param_row_alloc(): doing data from value

09:50:45.087976 param_row_alloc(): copying 8 bytes of data to parameter #2

09:50:45.087985 parm_info_alloc(): parameter null-ness = 1

09:50:45.087993 param_row_alloc, size = 0, offset = 12, row_size = 12

09:50:45.088001 param_row_alloc(): doing data from value

09:50:45.088007 param_row_alloc(): setting parameter #3 to NULL

09:50:45.088014 setting column 3 NULL bit

09:50:45.088023 tds_free_all_results()

09:50:45.088042 tds_put_data_info putting param_name 

09:50:45.088051 tds_put_data_info putting status 

09:50:45.088060 tds_put_data: is_null = 0, colsize = 3

09:50:45.088068 tds_put_data: not null param varint_size = 2

09:50:45.088107 tds_client_msg: #2402: "Error converting client characters 
into server's character set. Some character(s) could not be converted.".  
Connection state is now 0.  

09:50:45.088119 tds_put_data_info putting param_name 

09:50:45.088128 tds_put_data_info putting status 

09:50:45.088136 tds_put_data: is_null = 0, colsize = 10

09:50:45.088143 tds_put_data: not null param varint_size = 2

09:50:45.088168 tds_client_msg: #2402: "Error converting client characters 
into server's character set. Some character(s) could not be converted.".  
Connection state is now 0.  

09:50:45.088179 tds_put_data_info putting param_name 

09:50:45.088188 tds_put_data_info putting status 

09:50:45.088196 tds_put_data: is_null = 0, colsize = 8

09:50:45.088203 tds_put_data: not null param varint_size = 0

09:50:45.088210 tds_put_data_info putting param_name 

09:50:45.088229 tds_put_data_info putting status 

09:50:45.088238 tds_put_data: is_null = 1, colsize = 0

09:50:45.088246 tds_put_data: null param

09:50:45.088253 Sending packet

0000 03 01 00 8f 00 00 01 00-12 00 64 00 62 00 6f 00 |........ ..d.b.o.|

0010 2e 00 70 00 64 00 74 00-52 00 65 00 61 00 64 00 |..p.d.t. R.e.a.d.|

0020 49 00 73 00 73 00 75 00-65 00 72 00 73 00 00 00 |I.s.s.u. e.r.s...|

0030 04 40 00 63 00 63 00 79-00 00 af ff ff 09 04 c0 |.@.c.c.y .¯ÿÿ..À|

0040 00 33 04 40 00 69 00 73-00 73 00 00 a7 ff ff 09 |.3.@.i.s s..§ÿÿ.|

0050 04 c0 00 33 0c 40 00 70-00 72 00 69 00 63 00 69 |.À.3.@.p r.i.c.i|

0060 00 6e 00 67 00 44 00 61-00 74 00 65 00 00 3d 8c |.n.g.D.a t.e..=.|

0070 95 00 00 00 00 00 00 06-40 00 6c 00 61 00 62 00 |........ @.l.a.b.|

0080 65 00 6c 00 00 a7 ff ff-09 04 c0 00 33 ff ff    |e.l..§ÿÿ .À.3ÿÿ|

 

09:50:46.760649 in dbsqlok() 

09:50:46.760728 Received header

0000 04 01 00 11 00 33 01 00-                        |.....3..|

 

09:50:46.760755 Received packet

0000 fd 02 01 00 00 00 00 00-00                      |ý....... .|

 

09:50:46.760765 dbsqlok() marker is fd

09:50:46.760774 processing result tokens.  marker is  fd(DONE)

09:50:46.760784 tds_process_end: more_results = 0

            was_cancelled = 0

            error = 1

            done_count_valid = 0

09:50:46.760792 tds_process_end() state set to TDS_IDLE

09:50:46.760800 dbsqlok() end status was error

 

 




Notice to recipient:
The information in this internet e-mail and any attachments is confidential 
and may be privileged. It is intended solely for the addressee. If you are 
not the intended addressee please notify the sender immediately by telephone. 
If you are not the intended recipient, any disclosure, copying, distribution 
or any action taken or omitted to be taken in reliance on it, is prohibited 
and may be unlawful.

When addressed to external clients any opinions or advice contained in this 
internet e-mail are subject to the terms and conditions expressed in any 
applicable governing terms of business or client engagement letter issued by 
the pertinent Bank of America group entity.

If this email originates from the U.K. please note that Bank of America, 
N.A., London Branch, Banc of America Securities Limited and Banc of America 
Futures Incorporated are authorised and regulated by the Financial Services 
Authority.