# Transform Templates - Binary

This topic discusses application of the Transform pane with Tables on a binary field in a table, which is a data type varbinary.   See the Transform pane and Transform Templates topics for use and for links to lists of templates for other data types for tables and use of the Transform pane 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.     Example: Take the Geom field and use Compose WKB to put the WKB equivalent of the geom into WK binary geometry. 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.

Collations

Transform

Transform Pane

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