This is an automated email from the ASF dual-hosted git repository.
fanningpj pushed a commit to branch 1.2.x
in repository https://gitbox.apache.org/repos/asf/pekko-persistence-jdbc.git
The following commit(s) were added to refs/heads/1.2.x by this push:
new d3179dd use nvarchar instead of varchar for sql server (#382) (#385)
d3179dd is described below
commit d3179dd46f3f648bef90c321ecb94a91be8ca789
Author: PJ Fanning <[email protected]>
AuthorDate: Fri Nov 28 10:48:21 2025 +0100
use nvarchar instead of varchar for sql server (#382) (#385)
* use nvarchar instead of varchar for sql server
* undo
* Update sqlserver-create-schema.sql
---
.../schema/sqlserver/sqlserver-create-schema.sql | 24 +++++++++++-----------
1 file changed, 12 insertions(+), 12 deletions(-)
diff --git
a/core/src/main/resources/schema/sqlserver/sqlserver-create-schema.sql
b/core/src/main/resources/schema/sqlserver/sqlserver-create-schema.sql
index 51567ab..3794727 100644
--- a/core/src/main/resources/schema/sqlserver/sqlserver-create-schema.sql
+++ b/core/src/main/resources/schema/sqlserver/sqlserver-create-schema.sql
@@ -1,17 +1,17 @@
CREATE TABLE event_journal(
"ordering" BIGINT IDENTITY(1,1) NOT NULL,
"deleted" BIT DEFAULT 0 NOT NULL,
- "persistence_id" VARCHAR(255) NOT NULL,
+ "persistence_id" NVARCHAR(255) NOT NULL,
"sequence_number" NUMERIC(10,0) NOT NULL,
- "writer" VARCHAR(255) NOT NULL,
+ "writer" NVARCHAR(255) NOT NULL,
"write_timestamp" BIGINT NOT NULL,
- "adapter_manifest" VARCHAR(MAX) NOT NULL,
+ "adapter_manifest" NVARCHAR(MAX) NOT NULL,
"event_payload" VARBINARY(MAX) NOT NULL,
"event_ser_id" INTEGER NOT NULL,
- "event_ser_manifest" VARCHAR(MAX) NOT NULL,
+ "event_ser_manifest" NVARCHAR(MAX) NOT NULL,
"meta_payload" VARBINARY(MAX),
"meta_ser_id" INTEGER,
- "meta_ser_manifest" VARCHAR(MAX)
+ "meta_ser_manifest" NVARCHAR(MAX)
PRIMARY KEY ("persistence_id", "sequence_number")
);
@@ -19,7 +19,7 @@ CREATE UNIQUE INDEX event_journal_ordering_idx ON
event_journal(ordering);
CREATE TABLE event_tag (
"event_id" BIGINT NOT NULL,
- "tag" VARCHAR(255) NOT NULL
+ "tag" NVARCHAR(255) NOT NULL
PRIMARY KEY ("event_id","tag")
constraint "fk_event_journal"
foreign key("event_id")
@@ -28,14 +28,14 @@ CREATE TABLE event_tag (
);
CREATE TABLE "snapshot" (
- "persistence_id" VARCHAR(255) NOT NULL,
+ "persistence_id" NVARCHAR(255) NOT NULL,
"sequence_number" NUMERIC(10,0) NOT NULL,
"created" BIGINT NOT NULL,
"snapshot_ser_id" INTEGER NOT NULL,
- "snapshot_ser_manifest" VARCHAR(255) NOT NULL,
+ "snapshot_ser_manifest" NVARCHAR(255) NOT NULL,
"snapshot_payload" VARBINARY(MAX) NOT NULL,
"meta_ser_id" INTEGER,
- "meta_ser_manifest" VARCHAR(255),
+ "meta_ser_manifest" NVARCHAR(255),
"meta_payload" VARBINARY(MAX),
PRIMARY KEY ("persistence_id", "sequence_number")
)
@@ -50,12 +50,12 @@ CREATE TABLE durable_state
"global_offset" BIGINT
CONSTRAINT [df_global_offset] DEFAULT
(NEXT VALUE FOR global_offset),
- "persistence_id" VARCHAR(255) NOT NULL,
+ "persistence_id" NVARCHAR(255) NOT NULL,
"revision" NUMERIC(10, 0) NOT NULL,
"state_payload" VARBINARY(MAX) NOT NULL,
"state_serial_id" INTEGER NOT NULL,
- "state_serial_manifest" VARCHAR(MAX),
- "tag" VARCHAR(255),
+ "state_serial_manifest" NVARCHAR(MAX),
+ "tag" NVARCHAR(255),
"state_timestamp" BIGINT NOT NULL
PRIMARY KEY ("persistence_id")
);
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
