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
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
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!
Hello Mody Buchbinder,
Please try the following steps for a potential workaround:
Hope this helps!!