JonasR-
commented
4 years ago I just tried my idea. I created a new column for the hash and two trigger which are creating the hash on insert and update. Also I changed the term value type to MEDIUMTEXT and changed the index.
It works if I add/change a term over the database but I cant do it over the webinterface.
Is your feature request related to a problem? Please describe. I am currently trying to translate a application. There are tons of larger term e.g. email templates or pdf templates which have to be translated. At the moment I cant import them into traduora as the terms are to long for the DB field. From what I found out is that the value field in the terms table cant grow in size because of the index which is required for the unique.
Describe the solution you'd like Maybe a hash can be generated from the term value which is then used for the unique. With this solution we might be able to have larger terms.