aboutsummaryrefslogtreecommitdiff
path: root/sql
diff options
context:
space:
mode:
authorMickaël Rémond <mremond@process-one.net>2020-02-20 16:28:24 +0100
committerGitHub <noreply@github.com>2020-02-20 16:28:24 +0100
commit3947e6452481983a6125c258e990962a9b991d3d (patch)
tree972b79e400359264c50c36dfb5218e159190e1a4 /sql
parentSupport ejabberd_auth_http's auth_opts (processone/ejabberd-contrib#284) (diff)
parentallow storage of emojis in archive on mssql (diff)
Merge pull request #3127 from area-42/allow_emojis_with_mssql
allow storage of emojis in archive on mssql
Diffstat (limited to 'sql')
-rw-r--r--sql/mssql.sql4
1 files changed, 2 insertions, 2 deletions
diff --git a/sql/mssql.sql b/sql/mssql.sql
index 7bf5d6de8..c54f1ab35 100644
--- a/sql/mssql.sql
+++ b/sql/mssql.sql
@@ -26,8 +26,8 @@ CREATE TABLE [dbo].[archive] (
[timestamp] [bigint] NOT NULL,
[peer] [varchar] (250) NOT NULL,
[bare_peer] [varchar] (250) NOT NULL,
- [xml] [text] NOT NULL,
- [txt] [text] NULL,
+ [xml] [ntext] NOT NULL,
+ [txt] [ntext] NULL,
[id] [bigint] IDENTITY(1,1) NOT NULL,
[kind] [varchar] (10) NULL,
[nick] [varchar] (250) NULL,