Skip to Content.
Sympa Menu

freetds - Re: [freetds] UTF-8 conversion

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Eddie Gieze <egieze AT techno-design.com>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: Re: [freetds] UTF-8 conversion
  • Date: Fri, 22 Apr 2005 19:45:02 +0200

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





Archive powered by MHonArc 2.6.24.

Top of Page