Release Summary : 1. New and Updated Features : Support for Deprecated and New Microsoft SQL Server LOBs
 
Share this page                  
Support for Deprecated and New Microsoft SQL Server LOBs
Note:  Enterprise Access 3.0 no longer supports Microsoft SQL Server 2000. For more information about supported DBMSs, see the readme.
Microsoft has marked three Large Object types (LOBs) for future deprecation in Microsoft SQL Server. They are mapped to the following Enterprise Access types:
Microsoft SQL LOB
Enterprise Access Mapping
IMAGE
LONG BYTE
TEXT
LONG VARCHAR
NTEXT
LONG NVARCHAR
Enterprise Access now supports the following new LOBs, which Microsoft documents as the preferred types, introduced in Microsoft SQL Server 2005:
Enterprise Access Type
Supported Microsoft SQL LOB
LONG BYTE
VARBINARY(MAX)*
LONG VARCHAR
VARCHAR(MAX)*
LONG NVARCHAR
NVARCHAR(MAX)*
*MAX indicates the maximum storage size as 2^31 – 1 characters. This size matches the Ingres supported LOB size.
For more information about these new LOBs, see the Developing Portable Applications Guide.