Valuetype

The valuetype is used to convert the read value back to the original WinCC OA value and indicates which column should be read.

valuetype WinCC OA Element Type InfluxDB® Column Suffix and Type
0 bool bool
1 int int
2 unsigned int int
3 float float or float_special
4 string string
5 blob N/A
6 lang string string
7 char int
8 bit32 int
9 bit64 int
10 time int
11 dpid string
12 long int
13 unsigned long int
all dyn dyn

Notes

  • If the dyn column is not null, it has priority
  • if float_special is not null, it has priority over float
  • float_special is stored as string

The column with suffix _float_special contains the special float values values #inf and nan since InfluxDB® cannot map them to float values.