SQL string 8 caracters

[shotscope]

Hi,
I have implemented a dashboard where I query data from a SQL Server DB.
All looks good except the string.
It is always limited to 8 car.

is there any workaround I can use to display more car ?

Thanks

[Mikhail]

Hi,

Could you provide a screenshot?

[shotscope]

Hi,
Thank you for your reply.
Here is the picture : https://ibb.co/mHYpvbs

You can see the data I have in my database and in Rapid Scada interface I see it is truncate to 8 car.

[Mikhail]

Hi,

Thank you for the screenshot.
In Rapid SCADA 6 channels of the string type may contain more then 8 characters.
However, the DB import driver currently does not support long strings. The driver needs an update to implement the required feature.

[shotscope]

Thank you for your reply.

If I understand well, 2 problems
– SCADA channel that may contains > 8 car –> solved in version 6 (I can upgrade my system)
– Driver must be modified to take in account string > 8 car

Sorry if it is studi question but how to modifiy the driver ?
Any source code somewhere ?

[shotscope]

As a workaround:

In my SQL table I created 2 columns. and in my program I split the strting in with 8 car max.

In SCADA I created 2 fields showing column 1 and column 2

[Mikhail]

The above description is correct.

Sorry if it is studi question but how to modifiy the driver ?

1. Change the driver by yourself using the source code.
2. Sponsor the update, and we would implement the required feature.

Any source code somewhere ?

Driver’s source
See DrvDbImport projects. For example, DrvDsOpcUaServer supports long strings.

[Mikhail]

In SCADA I created 2 fields showing column 1 and column 2

Good workaround. Thank you for the idea.

[Author]

Posts