Table of Contents

Search

  1. Preface
  2. Introduction to Dynamic Data Masking
  3. Rules
  4. Connection Rules
  5. Security Rules
  6. Security Rule Set Simulator
  7. Masking Functions
  8. Stored Procedure Result Set Masking
  9. Integration with Informatica Products
  10. Appendix A: XML Functions Reference
  11. Appendix B: Glossary

Tabular Data Stream Protocol for Result Sets

Tabular Data Stream Protocol for Result Sets

Tabular Data Stream objects are converted between Microsoft SQL Server data types and Java types when the result set of a procedure call is created.
If the result set rewrite process encounters a column with an unsupported data type, the TDS protocol cannot create the result set. Consequently Dynamic Data Masking cannot mask any result set that contains a column with an unsupported data type, nor any other result sets subsequent to that result set in the response.
The following table shows the conversion that takes place between TDS types, Microsoft SQL Server data types, and Java types:
TDS Type
Microsoft SQL Server Type
Supported?
Fixed-Length Data Types
NULLTYPE = %x1F
Null
No
INT1TYPE = %x30
TinyInt
Yes
BITTYPE = %x32
Bit
Yes
INT2TYPE = %x34
SmallInt
Yes
INT4TYPE = %x38
Int
Yes
DATETIM4TYPE = %x3A
SmallDateTime
Yes
FLT4TYPE = %x3B
Real
Yes
MONEYTYPE = %x3C
Money
Yes
DATETIMETYPE = %x3D
DateTime
Yes
FLT8TYPE = %x3E
Float
Yes
MONEY4TYPE = %x7A
SmallMoney
Yes
INT8TYPE = %x7F
BigInt
Yes
Yes
Variable-Length Data Types
GUIDTYPE = %x24
UniqueIdentifier
No
INTNTYPE = %x26
(see below)
Yes
DECIMALTYPE = %x37
Decimal (legacy support)
Yes
NUMERICTYPE = %x3F
Numeric (legacy support)
Yes
BITNTYPE = %x68
Bit
Yes
DECIMALNTYPE = %x6A
Decimal
Yes
NUMERICNTYPE = %x6C
Numeric
Yes
FLTNTYPE = %x6D
Float
Yes
MONEYNTYPE = %x6E
SmallMoney/Money
Yes
DATETIMNTYPE = %x6F
(see below)
Yes
DATENTYPE = %x28
(introduced in TDS 7.3)
Yes
TIMENTYPE = %x29
(introduced in TDS 7.3)
Yes
DATETIME2NTYPE = %x2A
(introduced in TDS 7.3)
Yes
DATETIMEOFFSETNTYPE = %x2B
(introduced in TDS 7.3)
No
CHARTYPE = %x2F
Char (legacy support)
Yes
VARCHARTYPE = %x27
VarChar (legacy support)
Yes
BINARYTYPE = %x2D
byte[]
Yes
VARBINARYTYPE = %x25
VarBinary (legacy support)
Yes
BIGVARBINTYPE = %xA5
VarBinary
Yes
BIGVARCHRTYPE = %xA7
VarChar
Yes
BIGBINARYTYPE = %xAD
Binary
Yes
BIGCHARTYPE = %xAF
Char
Yes
NVARCHARTYPE = %xE7
NVarChar
Yes
NCHARTYPE = %xEF
NChar
Yes
XMLTYPE = %xF1
XML (introduced in TDS 7.2)
Yes
UDTTYPE = %xF0
CLR UDT (introduced in TDS 7.2)
No
TEXTTYPE = %x23
Text
Yes
IMAGETYPE = %x22
Image
No
NTEXTTYPE = %x63
NText
Yes
SSVARIANTTYPE = %x62
Sql_Variant (introduced in TDS 7.2)
No

0 COMMENTS

We’d like to hear from you!