Transform Templates - Binary

This topic discusses application of the Transform panel with Tables on a binary field in a table, which is a data type varbinary.   See the Transform panel and Transform Templates topics for use and for links to lists of templates for other data types for tables and use of the Transform panel with other components, such as Drawings and Images.

Tables, Varbinary Type

Compose WKB

Provides a way to extract geometry from a Manifold geometry type, a geom, into a well known binary representation of the geometry, WKB.  Given a geom field create a WKB binary value for that object.  Normally we would use the data type geomwkb for the destination field, but we can use varbinary for this example since we create variable length binary data.

 

il_binar_compose_wkb_dlg.png

 

Example: Take the Geom field and use Compose WKB to put the WKB equivalent of the geom into WK binary geometry.

 

il_trans_comp_wkb_binary.png

Copy

Copy the source field into the target field.

Limit

Limit the result at both the low end and also the high end, to no less than the limiting value in the At least field and also to no more than the limiting value in the At most field.  Save the Value field into the result,  unless that is below the At least field, in which case the At least field value is saved into the result, or unless that exceeds the At most field, in which case the At most field value is saved into the result.  Another way of looking at this is to take the Value field if it falls between the At least and At most fields, inclusive.   Yet another way is to consider simultaneously the At least field as the floor and the At most field the ceiling for what is taken from the Value field.

Limit High

Limit the result at the high end, to no more than the limiting value in the At most field.  Save the Value field into the result, unless that exceeds the At most field, in which case the At most field value is saved into the result.  Another way of looking at this is to take the minimum of the Value field or the At most field.  Yet another way is to consider the At most field the ceiling for what is taken from the Value field.

Limit Low

Limit the result at the low end, to no less than the limiting value in the At least field.  Save the Value field into the result, unless that is below the At least field, in which case the At least field value is saved into the result.  Another way of looking at this is to take the maximum of the Value field or the At least field.  Yet another way is to consider the At lease field the floor for what is taken from the Value field.

Parse Base64 String

Takes a base64-encoded string that encodes a binary value, retrieves the binary value and saves it into the target binary field.

Parse Hex String

Takes a hexadecimal-encoded string that encodes a binary value, retrieves the binary value and saves it into the target binary field.

Text Compare Key, Intl

Given a string generates a binary representation of the text, capturing the specified international options including the specified language.  The binary representations of the text can then be compared to each other to determine if a string is less than or greater than (meaning, comes before or comes after in dictionary order) another string.  The template allows choosing the language collation.  

 

See the Collations topic for a discussion of collations and examples of how to use the collation picker button in such transform templates.

 

Notes

There are 10 kinds of people in this world: Those who understand binary, and those who don’t.

 

See Also

Collations

 

Contents Pane

 

Transform

 

Contents - Transform

 

Transform Options

 

Transform Templates

 

Transform Templates - Drawings

 

Transform Templates - Images

 

Transform Templates - Boolean

 

Transform Templates - Datetime

 

Transform Templates - Geom

 

Transform Templates - Numeric

 

Transform Templates - Text

 

Transform Templates - Tile

 

Transform: Center and Centroids

 

Transform: Escape Templates