Unique constraints for LARGE TEXT columns – SQL
Suppose you are storing URL in your table and you want to apply UNIQUE contraint but as SQL allows only 900 byte limit. how can you put unique constraint for larger text ??
For this you can create a computed CHECKSUM column which is an integer vale and put constraint on it.
Example as follows
CREATE TABLE messages [...]
