The plugin allows to view the content of table column values in different formats. The available formats
depend on the data type of the column. The selected formats for the last 10 queries will be saved into the workspace file (*.iws) if
you select the option 'Save last table settings into workspace' on the 'Result' tab
of the plugin settings dialog.
The following formats are available.
String formats
Default | The string as it was returned by the database |
Bytes | The bytes of the string using the default character set. |
Bytes (ISO-8859-1) | The bytes of the string using the ISO-8859-1 character set. |
Bytes (UTF-8) | The bytes of the string using the UTF-8 character set. |
Bytes (UTF-16) | The bytes of the string using the UTF-16 character set. |
Flag (0 or 1) | A checkbox which is selected if the string is equal to "1". |
Number formats
Default | The string as returned by the toString() method of the number object. |
Dual | A string representation of the number as an integer in base 2. |
Flag (0 or 1) | A checkbox which is selected if the number is equal to 1. |
Hexadecimal | A string representation of the number as an integer in base 16. |
Java | A represenation of the number as it would be used in Java source code. |
Money | As money value in the current locale. |
Octal | A string representation of the number as an integer in base 8. |
Date formats
Default | A string representation of the date and time using the standard pattern of the current locale. |
Date and Time | A string representation of the date and time using the standard pattern of the current locale. |
Date only | A string representation of the date without the time using the standard pattern of the current locale. |
Millis | The number of milliseconds from 1.1.1970 0:00:00. |
Time only | A string representation of the time without the date using the standard pattern of the current locale. |
|