EVL – QVD Utils


Products, services and company names referenced in this document may be either trademarks or registered trademarks of their respective owners.

Copyright © 2017–2022 EVL Tool, s.r.o.

Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation License, Version 1.3 or any later version published by the Free Software Foundation; with no Invariant Sections, with no Front-Cover Texts, and with no Back-Cover Texts.

Table of Contents

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