Decimal
Decimal data type is defined by ‘decimal(m,n)’, where ‘m’ is number of all digits and ‘n’ is the number of decimal places. Decimal is EVL custom data type.
decimal(m,n)
when ‘n’ is missing, zero is supposed
size: 8 Bytes for ‘m’ up to 18 digits
size: 16 Bytes for ‘m’ from 19 to 38 digits
Next to standard EVD options (i.e. ‘sep=’, ‘null=’, ‘quote=’, ‘optional_quote=’) decimal and thousands separator can be specified:
- decimal_sep="."
to specify a decimal separator, which can be any single ascii character below 128; by default it is a decimal point
- thousands_sep=""
defines how to separate thousands, it can be any single ascii character below 128; by default there is no thousands separator.
An EVD file example:
revenues decimal(9,4) decimal_sep="," thousands_sep="." // e.g. 12.345,6789 expenses decimal(18) // e.g. 123456789012345678 taxes decimal(18,6) thousands_sep=" " // e.g. 123 456 789 012.345678 latitude decimal(10,6) // e.g. 49.8197203 longitude decimal(10,6) decimal_sep="," // e.g. 18,1673552