From 1f4316e65167f7d871c459413611985675538822 Mon Sep 17 00:00:00 2001
From: Simon Brandhof <simon.brandhof@sonarsource.com>
Date: Sat, 18 Aug 2018 14:36:57 +0200
Subject: [PATCH] SONAR-11168 support SQLServer collations longer than 30
 characters

---
 .../platform/db/migration/charset/MssqlMetadataReader.java      | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/server/sonar-db-migration/src/main/java/org/sonar/server/platform/db/migration/charset/MssqlMetadataReader.java b/server/sonar-db-migration/src/main/java/org/sonar/server/platform/db/migration/charset/MssqlMetadataReader.java
index bb395c26258..adbd16a7506 100644
--- a/server/sonar-db-migration/src/main/java/org/sonar/server/platform/db/migration/charset/MssqlMetadataReader.java
+++ b/server/sonar-db-migration/src/main/java/org/sonar/server/platform/db/migration/charset/MssqlMetadataReader.java
@@ -33,7 +33,7 @@ public class MssqlMetadataReader {
   }
 
   public String getDefaultCollation(Connection connection) throws SQLException {
-    return sqlExecutor.selectSingleString(connection, "SELECT CONVERT(VARCHAR, DATABASEPROPERTYEX(DB_NAME(), 'Collation'))");
+    return sqlExecutor.selectSingleString(connection, "SELECT CONVERT(VARCHAR(128), DATABASEPROPERTYEX(DB_NAME(), 'Collation'))");
   }
 
   public List<ColumnDef> getColumnDefs(Connection connection) throws SQLException {
-- 
2.39.5