Encountering an issue while creating an IVIEW with hard-coded Arabic content in the SQL query. After importing structures from the Oracle schema to the MS SQL schema, the form caption that contains Arabic text results in an Access Violation error upon opening. In contrast, other forms/IVIEWs without Arabic content in their captions open without any issues.
Additionally, we are unable to go online with the structures developed on the desktop due to the following error:
Error in - memrq: [Microsoft][SQL Server Native Client 11.0][SQL Server] Cannot resolve collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Arabic_CI_AS" in the concat operator for the CONVERT operation.