freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Re: [freetds] Requested: Clarification about TEXT type (0x23) on SqlServer

From: "James K. Lowden" <jklowden AT freetds.org>
To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
Subject: Re: [freetds] Requested: Clarification about TEXT type (0x23) on SqlServer
Date: Sat, 31 Mar 2007 09:30:54 -0400

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

[freetds] MS SQL Query for "Output Parameters (0xAC 172)" response token, Shama Dhume, 03/13/2007
- Re: [freetds] MS SQL Query for "Output Parameters (0xAC 172)" responsetoken, ZIGLIO, Frediano, VF-IT, 03/13/2007
  - [freetds] New Sybase datatype?, crawford charles, 03/14/2007
    - Re: [freetds] New Sybase datatype?, James K. Lowden, 03/14/2007
      - Re: [freetds] New Sybase datatype?, ZIGLIO, Frediano, VF-IT, 03/15/2007
        
        Re: [freetds] New Sybase datatype?, crawford charles, 03/15/2007
        
        Re: [freetds] New Sybase datatype?, ZIGLIO, Frediano, VF-IT, 03/15/2007
      - Re: [freetds] New Sybase datatype?, ZIGLIO, Frediano, VF-IT, 03/16/2007
        
        [freetds] Requested: Clarification about TEXT type (0x23) on SqlServer, crawford charles, 03/30/2007
        
        Re: [freetds] Requested: Clarification about TEXT type (0x23) on SqlServer, James K. Lowden, 03/31/2007
        
        Re: [freetds] Requested: Clarification about TEXT type (0x23) on SqlServer, crawford charles, 03/31/2007
        Re: [freetds] Requested: Clarification about TEXT type (0x23) on SqlServer, James K. Lowden, 03/31/2007