Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-45945

MS-SQL Collation in Temp Tables (as seen in LDAP Auth Import)

    XMLWordPrintable

    Details

      Description

      When running the LDAP Sync an error message is displayed stating that a collation conflict is causing a compare issue and no records are returned.

      This seems to be happening because the collation settings on the MS SQL 2008 R2 Master DB are different from the Collation settings on the Moodle database. When a temp table is created (as it apparently is in the LDAP sync operation) it is created with the collation of the TempDB, by default, which is inherited from the MasterDB.

      The creation query of the temp table should be modified to contain 'COLLATE database_default' so that it inherits the collation of the Moodle database rather than the instance default.

      The error message is posted at:
      https://moodle.org/mod/forum/discuss.php?d=261836

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:
                  Fix Release Date:
                  14/Jul/14