MySQL Forums
Forum List  »  Connector/ODBC

Re: incorrect string value
Posted by: Артём Будейкин
Date: January 12, 2021 11:54AM

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

Options: ReplyQuote




Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.