Change the collation for proposal title and protein name to utf8mb4_unicode_ci about ispyb-database-modeling HOT 6 OPEN

I agree, this makes sense. We actually already have the utf8mb4_unicode_ci ollation on our Proposal.title at Diamond. But not on Protein.name.

I think these SQL statements will do the job:

ALTER TABLE Proposal MODIFY title varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;
ALTER TABLE Protein MODIFY name varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;

from ispyb-database-modeling.

Done with script : 2018_03_13_updateCollations.sql

from ispyb-database-modeling.

We face the same type of problems with Macromolecule.name .acronym, .comments
So we will change the collation accordingly.

from ispyb-database-modeling.

I cannot agree with acronym. This field is piped to the filesystem where we really do not want special characters.

from ispyb-database-modeling.

Sorry to clarify, macromolecule.acronym or protein.acronym? (why are these different tables? separate discussion). If macromolecule i assume this a SAXS issue?

from ispyb-database-modeling.

Yes, it is a SAXS issue, and in fact not necessary to change Macromolecule.acronym as it is filtered beforehand.

from ispyb-database-modeling.