FreeTDS Development Group

[crawford charles <fiducianettestz AT yahoo.com>]

Mr. Lowden,

Thank you, sir.

That bit about the collation was enlightening.  I
have avoided trying to grok the complexity of the
collation information until now.  I have found a
few pages on MSDN about them, and particularly
copying data between different collations, I can
tell this is going to be a long study.

I had expected that TXTPTR would be present for
TEXT type, but I think I have an example of a
client RPC packet (0x03) where a TEXT parameter
does not have TTXTPTR but does have COLLATE.  I
had hoped to attach an example capture file, but
I'm still trying to remove identifying information
from it...

One more question, if your would be so kind:
what does it mean when a RESULT (0x81) response
token has a length of -1 (0xFFFF).  This is in
response to a sp_cursor RPC(core id == 1).  I infer
that it may mean "refer to previous RESULT", or
perhaps some default, but it is not immediately
obvious.

Thank you again for all your help, and for FreeTDS.

C.
--- "James K. Lowden" <jklowden AT freetds.org> wrote:

> crawford charles wrote:
> > I have been looking at some traces of version 7.1
> > SqlServer traffic, and I am confused about TEXT
> > (0x23).
> > 
> > Does this have a TXTPTR (as it does in SYBASE),
> and is
> > it supposed to be UCS2 or ASCII?
> 
> It does have a txtptr.  It's neither UCS-2 nor
> ASCII, precisely speaking. 
> It's single-byte encoded according to the codepage
> (or maybe they call it
> "collation") for that column on the server.  
> 
> HTH. 
> 
> --jkl


 
____________________________________________________________________________________
No need to miss a message. Get email on-the-go 
with Yahoo! Mail for Mobile. Get started.
http://mobile.yahoo.com/mail