"force truncation on varchar modification?" Code Answer

3

you can manually truncate the column at 255 characters:

update striker
set    contacts = substr (contacts, 1, 255);

now, that you know that no value is longer than 255 characters, you perform the alter table statement you have in the op safely.

By smbergin79 on July 14 2022

Answers related to “force truncation on varchar modification?”

Only authorized users can answer the Search term. Please sign in first, or register a free account.