大网数据广告活动
磁盘与文件系统

Tagged, Fixed and Variable Columns

· 52CE 我爱测

Learn more about: Tagged, Fixed and Variable Columns

Applies to: Windows | Windows Server

Tagged, Fixed and Variable Columns

Tagged, fixed, and variable-length columns are the primary column types supported by ESE. Tagged columns are not present in a record unless data is stored in the column, and may be fixed or variable length. Tagged columns can also contain more than one value in a single record. Fixed columns take the same amount of space in every row, and require 1 bit to represent the NULL value. Variable length columns require 2 bytes to represent the size and NULL value, and occupy a variable amount of space in each record. For more information on the tagged and fixed columns, see the Jet_bitColumnTagged, and Jet_bitColumnFixed option in the grbit member of JET_COLUMNDEF structure used in the call to JetAddColumn.

Variable-length columns are determined by the column type that is set in the coltyp parameter in the call to JetAddColumn. The following column types may be fixed or variable length depending on whether the Jet_bitColumnFixed option is set:

  • JET_coltypBinary

  • JET_coltypText

  • JET_coltypLongBinary

  • JET_coltypLongText

In general, data in the record is stored with the fixed range first, the variable range next, and the tagged range stored last. The following diagram shows how the records are stored in the table. As shown in the diagram, the tagged range may contain columns with multiple values.

ESE_Documentation_TagFixVar

Source: Microsoft Learn / Windows Win32 documentation by Microsoft and contributors. Documentation licensed CC BY 4.0. Code samples are covered by the MIT License. Converted from Markdown, with links normalized and embedded media omitted.

资料来源与适用范围

资料来源
Microsoft Learn / Windows Win32 documentation
适用范围
Windows Win32 API · Source date 04/11/2016
内容语言
中文;命令、路径和错误标识保留技术原文
本地收录日期
2026-11-15
授权说明
CC BY 4.0 (documentation), MIT (code samples)

正文与所需资源由本站本地存储。查看来源及更新记录 ↗

请按适用版本和实际日志确认原因;本站没有对每一种系统或设备逐项执行文中的操作。