Change NVARCHAR to VARBINARY in mssql
@@ -448,7 +448,7 @@ CREATE TABLE SP_AUTH_SCRIPT (
TENANT_ID INTEGER NOT NULL,
APP_ID INTEGER NOT NULL,
TYPE VARCHAR(255) NOT NULL,
- CONTENT NVARCHAR(MAX) DEFAULT NULL,
+ CONTENT VARBINARY(MAX) DEFAULT NULL,
IS_ENABLED CHAR(1) NOT NULL DEFAULT '0',
PRIMARY KEY (ID)
);
@@ -459,7 +459,7 @@ CREATE TABLE SP_TEMPLATE (
TENANT_ID INTEGER NOT NULL,
NAME VARCHAR(255) NOT NULL,
DESCRIPTION VARCHAR(1023),
- CONTENT NVARCHAR(MAX) DEFAULT NULL,
+ CONTENT VARBINARY(MAX) DEFAULT NULL,
PRIMARY KEY (ID),
CONSTRAINT SP_TEMPLATE_CONSTRAINT UNIQUE (TENANT_ID, NAME)
);
@@ -865,7 +865,7 @@ CREATE TABLE IDN_SAML2_ARTIFACT_STORE (
ID INTEGER NOT NULL IDENTITY,
SOURCE_ID VARCHAR(255) NOT NULL,
MESSAGE_HANDLER VARCHAR(255) NOT NULL,
- AUTHN_REQ_DTO NVARCHAR(MAX) NOT NULL,
+ AUTHN_REQ_DTO VARBINARY(MAX) NOT NULL,
SESSION_ID VARCHAR(255) NOT NULL,
INIT_TIMESTAMP DATETIME NOT NULL,
EXP_TIMESTAMP DATETIME NOT NULL,
