Base/Data Types
{{#vardefine:v1|0}}
{{#if:
| {{#vardefine:v1|{{#expr:{{#var:v1}}+1}}}} |
}}{{#ifexist:{{#rel2abs: ../preload}}
| {{#vardefine:v1|{{#expr:{{#var:v1}}+1}}}} |
}}{{#ifexist:{{#rel2abs: ../preload1}}
| {{#vardefine:v1|{{#expr:{{#var:v1}}+1}}}} |
}}{{#ifexist:{{#rel2abs: ../preload2}}
| {{#vardefine:v1|{{#expr:{{#var:v1}}+1}}}} |
}}{{#ifexist:{{#rel2abs: ../preload3}}
| {{#vardefine:v1|{{#expr:{{#var:v1}}+1}}}} |
}}{{#ifexist:{{#rel2abs: ../preload4}}
| {{#vardefine:v1|{{#expr:{{#var:v1}}+1}}}} |
}}{{#ifexist:{{#rel2abs: ../preload5}}
| {{#vardefine:v1|{{#expr:{{#var:v1}}+1}}}} |
}}{{#ifexist:{{#rel2abs: ../preload6}}
| {{#vardefine:v1|{{#expr:{{#var:v1}}+1}}}} |
}}{{#ifexist:{{#rel2abs: ../preload7}}
| {{#vardefine:v1|{{#expr:{{#var:v1}}+1}}}} |
}}{{#ifexist:{{#rel2abs: ../Template:NeedsRework}}
| {{#vardefine:v1|{{#expr:{{#var:v1}}+1}}}} |
}}{{#ifexist:{{#rel2abs: ../../rules/templates}}
| {{#vardefine:v1|{{#expr:{{#var:v1}}+1}}}} |
}}{{#ifexpr:{{#expr:{{#var:v1}}>0}}
| |
}}
{{#switch:EN | RU = Эта статья должна быть проверена на точность и соответствие стилю. | UA = Ця стаття повинна бути перевірена на точність і відповідність стилю. | EN = This article should be checked for accuracy and conformity to style. | PT = Este artigo deve ser verificado quanto à precisão e conformidade ao estilo. | #default = Эта статья должна быть проверена на точность и соответствие стилю. (This article should be checked for accuracy and conformity to style) }}
Variable Types for Embedded Base Database
Numeric Types
2-1074 to (2-2-52)* 21023 could also be stated as 5e-324 to 1.7976931348623157e+308
Alphanumeric Types
2GB for 32 bit OS | Stores up to the max number of characters indicated by user. It accepts any UTF 8 character. | ||
2GB for 32 bit OS | Stores exactly the number of characters specified by user. Pads with trailing spaces for shorter strings. Accepts any UTF 8 character. | ||
2GB for 32 bit OS | Stores up to the specified number of characters. No padding (Same as long var char). | ||
2GB for 32 bit OS | Stores up to the specified number of characters. Comparisons are not case-sensitive, but stores capitals as you type them. |
Binary Types
2GB for 32 bit OS | Stores any array of bytes (images, sounds, etc). No validation required. | ||
2GB for 32 bit OS | Stores any array of bytes. No validation required. | ||
2GB for 32 bit OS | Stores any array of bytes. No validation required. |
Date time
Name | Description | Format |
Date | Stores month, day and year information | 1/1/99 to 1/1/9999 |
Time | Stores hour, minute and second info | Seconds since 1/1/1970 |
Timestamp | Stores date and time information |
Other Variable types
Description | |
Other | Stores serialized Java objects. User application must supply serialization routines. |
Object | Same |