Export to DB – String variables

[JD]

I am using the Export to DB module, attached to a MySQL database.
I have a tag which is a string (ASCII Text on SCADA-Administrator) that is displayed correctly on the web station.

On the MySQL database it is shown as float and thus has no sense. How can I log it to string type or at least how can I decode the stored float value to the expected string? CONVERT and CAST functions of MySQL do not work.

[Mikhail]

The idea of conversion:
Convert the value of double type to 8 bytes. Each byte is a character.

public static string DecodeAscii(double val)
{
    byte[] buf = BitConverter.GetBytes(val);
    return Encoding.ASCII.GetString(buf).TrimEnd((char)0);
}

You should create a function in your database that performs this conversion.

[Author]

Posts