FreeTDS Development Group

[Eddie Gieze <egieze AT techno-design.com>]

Hello James,

Thanks for your help. I've tried out your test and this is what i get:

00000000  6c 6f 63 61 6c 65 20 69  73 20 22 43 22 0a 6c 6f  |locale is 
"C".lo|
00000010  63 61 6c 65 20 63 68 61  72 73 65 74 20 69 73 20  |cale 
charset is |
00000020  22 55 53 2d 41 53 43 49  49 22 0a 31 3e 20 32 3e  
|"US-ASCII".1> 2>|
00000030  20 31 3e 20 32 3e 20                              | 1> 2> |
00000037

Manually i get this:

1> select content, cast(content as varbinary(40)) as HexContent from 
tblitem where id = 1317
2> go
Msg 529, Level 16, State 2, Server EDDIEXP\MSDE2000, Line 1
Explicit conversion from data type ntext to varbinary is not allowed.
1>

I'm glad the problem seems to be me.. I wonder what i'm doing wrong.

Grtz,
Eddie

On Apr 22, 2005, at 7:16 PM, Lowden, James K wrote:
> *Maybe* token.c is misparsing the packet, but I think it's more likely
> you're not getting from the server what you think you're getting.
>
> To confirm, this might be an interesting test:
>
> $ printf '%s\ngo\n'     \
>         'SELECT name,
>                 content,
>                 cast(content as varbinary(40)) as HexContent
>          FROM tblite m WHERE  id = 1317' \
> | tsql -S$S -U$U -P$P | hexdump -C
>
> HTH.
>
> --jkl