Line: 1 to 1 | ||||||||
---|---|---|---|---|---|---|---|---|
APPX 6.1.0 Features_This page provides an overview of the new features in APPX 6.1.x | ||||||||
Line: 65 to 66 | ||||||||
APPX_PDF_FONT_PATH=<location of font files, default $APPXPATH/fonts/>
APPX_PDF_FONT_MONO=DejaVuSansMono APPX_PDF_FONT_MONO_BOLD=DejaVuSansMono-Bold APPX_PDF_FONT_MONO_ITALIC=DejaVuSansMono-Oblique APPX_PDF_FONT_MONO_BOLD_ITALIC=DejaVuSansMono-BoldOblique APPX_PDF_FONT_SANS=DejaVuSans APPX_PDF_FONT_SANS_BOLD=DejaVuSans-Bold APPX_PDF_FONT_SANS_ITALIC=DejaVuSans-Oblique APPX_PDF_FONT_SANS_BOLD_ITALIC=DejaVuSans-BoldOblique APPX_PDF_FONT_SERIF=DejaVuSerif APPX_PDF_FONT_SERIF_BOLD=DejaVuSerif-Bold APPX_PDF_FONT_SERIF_ITALIC=DejaVuSerif-Italic APPX_PDF_FONT_SERIF_BOLD_ITALIC=DejaVuSerif-BoldItalic | ||||||||
Added: | ||||||||
> > | Unicode Fields and CollationUnicode fields are using collation for sorting and comparison instead of ASCII character codes. This causes some behavioral differences between raw fields and Unicode fields in APPX that you should be aware of. Sorting a Unicode field can have a different result from sorting a Raw field. Since APPX uses collation for sorting Unicode fields, depending on the collation used, you may see different sorting results. Here is an example that shows the differences in result of sorting a Unicode field and a raw field with similar values: RAW -------- Unicode In this case APPX uses the default system collation on a Windows 10 machine which is "en_US". Queries also use collation to sort Unicode fields. So, sorting a Unicode field and a raw field with similar data may result in different sort order. You can use "APPX_QSORT_COL_NAME" and "APPX_QSORT_COL_STRENGTH" environment variables to change the collation used in query processes to sort Unicode fields. If these environment variables are not specified APPX uses the system's collation which also can be overridden (see below). Comparing Unicode Alpha fields may surprise you. If you are using Raw alpha field and run a statement like:The result will be TRUE since ASCII code for character 'a' is larger than 'A'. However, if you run the same statement on Unicode fields (based on the collation used) the result may be FALSE. In case of "en_US" collation, the result will be FALSE but if you use "en_US_POSIX" collation, the result will be TRUE. You can override the collation APPX uses by setting “APPX_UCODE_COL_NAME” and “APPX_UCODE_COL_STRENGTH” environment variables. However, there are some things you need to consider before doing that:
| |||||||
64-bit APPXAPPX 6.1 has been updated to run as a 64-bit application on some platforms. |