Cannot resolve the collation conflict between "Latin1_General_CI_AI" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation

[Former Member]

hi, While update i am getting this error, anyone help me in solving this error.

ERROR [hybrisHTTP30] [Initialization] com.microsoft.sqlserver.jdbc.SQLServerException: Cannot resolve the collation conflict between "Latin1_General_CI_AI" and "SQL_Lat in1_General_CP1_CI_AS" in the equal to operation. org.apache.ddlutils.DatabaseOperationException: com.microsoft.sqlserver.jdbc.SQLServerException: Cannot resolve the collation conflict between "Latin1_General_CI_AI" an d "SQL_Latin1_General_CP1_CI_AS" in the equal to operation. at org.apache.ddlutils.platform.PlatformImplBase.readModelFromDatabase(PlatformImplBase.java:1931) ~[ddlutils-1.0.jar:1.0] at org.apache.ddlutils.platform.PlatformImplBase.readModelFromDatabase(PlatformImplBase.java:1904) ~[ddlutils-1.0.jar:1.0]

[arvind-kumar_avinash]

Please execute the following SQL and try again:

 ALTER DATABASE your-database-name COLLATE Latin1_General_CI_AS

You can check https://docs.microsoft.com/en-us/sql/relational-databases/collations/set-or-change-the-database-coll... for more information.

You can also check if https://www.mssqltips.com/sqlservertip/4395/understanding-the-collate-databasedefault-clause-in-sql-... is of any help.

[Former Member]

HI, changed to Latin1_General_CI_AI, Update completed, but showing the following error multiple times while update

ERROR [hybrisHTTP7] (00005N5S) [FlexibleSearch] Flexible search error occured... ERROR [hybrisHTTP7] (00005N5S) [Job] Caught throwable SQL search error - enable the property 'flexible.search.exception.show.query.details' for more details de.hybris.platform.jalo.flexiblesearch.FlexibleSearchException: SQL search error - enable the property 'flexible.search.exception.show.query.details' for more details[H Y-0] at de.hybris.platform.jalo.flexiblesearch.internal.FlexibleSearchExecutor.execute(FlexibleSearchExecutor.java:183) at de.hybris.platform.jalo.flexiblesearch.FlexibleSearch.executeSearch(FlexibleSearch.java:1810)

Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Cannot resolve collation conflict between "Latin1_General_CI_AI" and "SQL_Latin1_General_CP1_CI_AS" in UNION ALL operator occurring in GROUP BY statement column 3. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:259)

Thanks