Azure Sql with different collation

1159
3
01-09-2020 06:31 AM
ModyBuchbinder
Esri Regular Contributor

Hi All

We would like to create a Geodatabase in Azure SQL

The problem is that we would like to have different collation then the default.

We cannot use Create Enterprise Geodatabase because you get the default collation.

We created a database with our collation and tried to use Enable Geodatabase

we got this error:

 

Failed to create stored procedures in the geodatabase. Error (-51)

  DBMS error code: 468

[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Cannot resolve the collation conflict between "Hebrew_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation

Any ideas?

Thanks

0 Kudos
3 Replies
ModyBuchbinder
Esri Regular Contributor

It looks like the Sql in Azure have some kind of UTF8 collation so it support other Languages even when it set to Latin.

We used the default and we have no problem with Hebrew

ModyBuchbinder
Esri Regular Contributor

After working with the geodatabase we found that Hebrew is displayed but query fail.

You can add an Upper case N to the string in the query to make it works but some other clients that does not give an option to "build" a query (such as Dashboard) fail.

If anybody have any idea it will be great!

Thanks 

0 Kudos
Roshan_MarkSingh_Matharu
Esri Contributor

Hello Mody Buchbinder,

Please try the following steps for a potential workaround: 

Hope this helps!! 

Kind regards,

Mark

0 Kudos