I am currently working on a project where I want wo collect some data from a specific Machine. With that data there comes an Identifier which identifies the Object that's worked on, so it's kind of clear that this has to be an accurateley displayed Number. It is currently saved as a String in an MS SQL Database.

Query: Click here to see a snippet of my SQL generated Query

However, Grafana seems to have a problem with displaying the Identifier - and only the Identifier - the right way:

Click here to see a snippet of my Grafana Table

Just to visualize what my problem is:

Identifier displayed in SQL:      252010387528000096
Identifier displayed in Grafana:  252010387528000100

I've already checked for this behaviour on my other Grafana Boards but I couldn't seem to find out what causes the problem.

My SQL Query I used in both SQL and Grafana:

SELECT
  [time],
  [Index],
  [Identifier],
  [WaitingJamTime],
  [WaitingPartMissing],
  [ProcessingTime],
  [RunningInTime],
  [RunningOutTime],
  [Station],
  [Result],
  [ScanQualiSerial],
  [ScanQualiGehaeuse]
FROM
  [048115_PSDC]
WHERE
  [Station] = '458106101' AND
  $__timeFilter(time)
ORDER BY
  time desc