17.10 - Bit and Byte Numbering Model - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - SQL Functions, Expressions, and Predicates

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-28
dita:mapPath
SQL_Functions__Expressions__and_Predicates.Upload_071421/djk1612415574830.ditamap
dita:ditavalPath
SQL_Functions__Expressions__and_Predicates.Upload_071421/wrg1590696035526.ditaval
dita:id
kby1472250656485

The following diagrams show the logical bit and byte numbering model employed by the byte/bit manipulation functions described in these sections.

The model is big endian or little endian independent. Note that the numbering system used for numeric data types is consistent with that used for byte strings. This simplifies the development of appropriate bit masks.

Users of the byte/bit manipulation functions should mentally visualize the numeric and byte data types as shown below when contemplating what masks (bit_mask_arg) need to be applied to the target data (target_arg).