DB Import string

[oley]

Hi,

I use DrvDbImport 6.1.0.1 to communicate with PostgrSQL DB.
It works, but I become only first 4 characters for string columns.
I have set the data type of the channel to ASCI and Unicode string and format to String.

Best regards

[manjey73]

Specify the required length for the channel, and set the next channel number based on the length of the previous one.
For example, Channel 200 is a String type, length 2, the next channel should be 202, since you set the length to 2 and occupied channels 200 and 201.

[JurasskPark]

https://raw.githubusercontent.com/JurasskPark/RapidScada_v6/master/OpenDrivers/Source/DrvDbImportPlus_007.png

https://rapidscada.net/store/Module/en/KpDbImportPlus
😀

[oley]

Thank you but I do not really understand that.
If I will read multiple strings from DB, should they have fixed length?
Is this length in characters?
If I have only one string from another table, do I have to create another “dummy” channel to set the length of the previous one?

@JurasskPark I will take a look at this module.

[JurasskPark]

If I will read multiple strings from DB, should they have fixed length?
Is this length in characters?

You must calculate in advance what the maximum length of characters in a string will be. For this maximum length, and book the number of tags / 4 characters.

[Mikhail]

Hi,
Currently long strings are not supported by the DrvDbImport drvier. I hope, we will implement it in the future.
If the strings have fixed values, they can be presented as numbers, and enumerations can be used.
Alternatively, use the community driver noticed above.

[oley]

All right, thank you!

[Author]

Posts