When I run a sql update query to update a comments field in a table from a import sheet, it truncates the comment to 255 characters even though both of the relevant fields in each table are set to long text.
It's almost as if they're converting the text to short text in the update. I have checked before the update and there were indeed specific entries where a comment had far more than 255 characters that became truncated to 255 after the update.
The code looks like this:
Code:
Update table AS T
Inner Join import_sheet AS I
ON T.Key = I.Key
SET
T.field1 = I.field1
T.field2 = I.field2
...
WHERE
T.user = 'user1' Or
T.user = 'user2' Or
...
;
Any idea on what's going on and how I can work around this issue if it's not fixable?