This topic accompanies the Styling Table Fields topic to provide reference detail on styling fields in tables for binary, boolean, and UUID data types. Please review the Styling Table Fields topic for an introduction and step by step examples before proceeding with this topic.
Binary styles are simple, with the choice of reporting the field content as varbinary data, as in <varbinary>, or as reporting the field content as varbinary data with the number of bytes <varbinary,149 b>, the default.
Language choices will affect the separator character used in the style and in the number of bytes. For example, a comma , character is used as a separator for neutral and US English, and a dot . character used as a separator when a European language is specified. The separator character between displayed parts of the style will also switch to match the language, for example, switching to a semicolon ; character for German in Germany. For example, <varbinary, 4,836 b> for English in the US as compared to <varbinary; 4.836 b> for German in Germany.
The number of bytes reported is the number of bytes in the value as it is stored in a .map file, with some compression already applied.
b |
Data type name: <varbinary> |
B |
Data type name with number of bytes (default): <varbinary, XXX b> |
Using the B option with neutral choice of Language:
Using the B option with de-DE (German as used in Germany) choice of Language:
Provides a choice of displaying TRUE and FALSE Boolean values as the numbers 1 and 0 or as the words true and false, or TRUE and FALSE.
b |
Display TRUE as 1 and FALSE as 0. |
t |
Display TRUE as true and FALSE as false. The default. |
T |
Display TRUE as TRUE and FALSE as FALSE. |
Using the T option:
When entering new records or editing Boolean fields in existing records, Boolean fields always show a pop-up menu choice of true or false, with no need to explicitly specify choices as described in the Styling Choices in Tables topic, since there are always only two possible choices for Boolean fields.
The only two options for UUID fields is to use lower case (the default) or upper case for letters that are part of the hexadecimal UUID.
x |
Lower case letters: a0341f38-2cbe-4098-9669-4aa88e659f9e |
X |
Upper case letters: A0341F38-2CBE-4098-9669-4AA88E659F9E |
The default, using lower case letters:
Using the X style for upper case letters:
There is no language option for UUID fields, since the styles are the same for all languages and countries.