Re: incorrect string value
This table works fine:
gdis_researchparamblobvalues', 'CREATE TABLE `gdis_researchparamblobvalues`
(
\n `ResearchId` int NOT NULL,
\n `ParameterId` int NOT NULL,
\n `Diagram` longblob,
\n KEY `Idx_ResearchId` (`ResearchId`),
\n KEY `Idx_ParameterId` (`ParameterId`),
\n CONSTRAINT `FK_gdis_ResearchParamBlobValues_gdis_Researches` FOREIGN KEY (`ResearchId`) REFERENCES `gdis_researches` (`Id`) ON DELETE CASCADE ON UPDATE CASCADE,
\n CONSTRAINT `FK_gdis_ResearchParamBlobValues_Parameters` FOREIGN KEY (`ParameterId`) REFERENCES `parameters` (`Id`) ON DELETE CASCADE ON UPDATE CASCADE
\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci
and this doesn't:
gdis_versionparamblobvalues', 'CREATE TABLE `gdis_versionparamblobvalues` (
\n `VersionId` int NOT NULL,\n `ParameterId` int NOT NULL,
\n `Diagram` longblob,\n KEY `Idx_VersionId` (`VersionId`),
\n KEY `Idx_ParameterId` (`ParameterId`),
\n CONSTRAINT `FK_gdis_VersionParamBlobValues_gdis_IntVersions` FOREIGN KEY (`VersionId`) REFERENCES `gdis_intversions` (`Id`) ON DELETE CASCADE ON UPDATE CASCADE,
\n CONSTRAINT `FK_gdis_VersionParamBlobValues_Parameters` FOREIGN KEY (`ParameterId`) REFERENCES `parameters` (`Id`) ON DELETE CASCADE ON UPDATE CASCADE
\n) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci