Data type when a virtual table is taken in

There are four data types of a virtual table and by default the data is taken in by setting one of the following formats.

In the Virtual Table Settings screen, you can set the format of the data when it is taken into a virtual table.

Character string

N, M, X, W, and CSV character string

Numeric value

9, F, S, P, B, Z and CSV numeric value

Date

D

Binary

I
Note

  • When importing data from a virtual table, characters are converted to UTF-8 beforehand.

    When imported data contains external characters, all external characters other than UTF-8, Shift JIS, IBM Kanji, and UTF-16 will be converted to the default code ("□" white square).

  • When a field of the numeric type stores a numeric value that exceeds 15 digits, a rounding error might be generated.

  • A field with no value is imported as a NULL character regardless of the field type. Therefore, when data is imported by using a query value, a imported value might be a NULL character and as a result might not match with an input value. To avoid the situation, use the COALESCE function, which can be used in a query against a virtual table.

    For details about functions, see Functions that can be used in a query.