Is it possible to change the History table default varchar(255) "stringvalue" to something larger?

[Bob]

Is it possible to change the History table default varchar(255) size for the “stringvalue” column to something larger?

I’m sure I can do this manually, but I would like all the partition tables that get created automatically by the Gateway History settings to use the larger “stringvalue” column size also.

I am using Ignition v7.9.2

Thank you,
Bob

[justin.brzozoski]

There are some workable solutions over in this thread:

Tag history string length

Using version 8.1.2 I started with internal tag history which worked great with long JSON strings. I added a push to remote server using MariaDB connection with regular tag historian db. I updated the Table definition as varchar(10000) but still getting error message. java.sql.BatchUpdateException: Data truncation: Data too long for column ‘stringvalue’ at row 1