SQL adaptation guide For SQL SERVER 2005, 2008, 2012 / Data dictionary |
Informix® and Genero support the TEXT and BYTE types. TEXT is used to store large text data, while BYTE is used to store large binary data like images or sound.
Microsoft™ SQL SERVER 2005 and higher provides the varchar(max), nvarchar(max) and varbinary(max) data types to store large object data. The text, ntext and image data types still exist, but are considered as obsolete and will be removed in a future version.
In SQL Server, the varchar(max), nvarchar(max) and varbinary(max) types have a limit of 2 gigabytes (2^31 -1 actually). The old text, ntext and image types have the same limit.
In Genero programs connecting to SQL SERVER, the TEXT and BYTE data types of DDL statements such as CREATE TABLE are respectively converted to varchar(max) and varbinary(max) types.
SQL SERVER database drivers make the appropriate bindings to use TEXT and BYTE Genero types as SQL parameters and fetch buffers, and can be used for SQL SERVER text, image or varchar(max), nvarchar(max) and varbinary(max) columns.
Genero TEXT/BYTE program variables and the SQL SERVER large object types have the same a limit of 2 gigabytes.