MS SQL collation table

XMLWordPrintable

      Hello. I have some problems.

      I use  [instruction|https://confluence.atlassian.com/jirakb/how-to-fix-the-collation-of-a-microsoft-sql-server-jira-database-776646810.html]

       When I import Tables to the New Database I get warning

       

      // code placeholder arning! The maximum key length is 900 bytes. The index 'index_ao_0ae25b_hiscf_assignee' has maximum length of 1020 bytes. For some combination of large values, the insert/update operation will fail.
Warning! The maximum key length is 900 bytes. The index 'index_ao_0ae25b_his2020257448' has maximum length of 1020 bytes. For some combination of large values, the insert/update operation will fail.
Warning! The maximum key length is 900 bytes. The index 'index_ao_589059_rul1206101986' has maximum length of 1020 bytes. For some combination of large values, the insert/update operation will fail.
Warning! The maximum key length is 900 bytes. The index 'index_ao_589059_rul1912897271' has maximum length of 1020 bytes. For some combination of large values, the insert/update operation will fail.
Warning! The maximum key length is 900 bytes. The index 'TLFIELDVALUE_INDX4' has maximum length of 1020 bytes. For some combination of large values, the insert/update operation will fail.
Warning! The maximum key length is 900 bytes. The index 'TLFIELDVALUE_INDX1' has maximum length of 1920 bytes. For some combination of large values, the insert/update operation will fail.
Warning! The maximum key length is 900 bytes. The index 'TLFIELDVALUE_INDX2' has maximum length of 1411 bytes. For some combination of large values, the insert/update operation will fail.
Warning! The maximum key length is 900 bytes. The index 'idx_group_attr_dir_name_lval' has maximum length of 1029 bytes. For some combination of large values, the insert/update operation will fail.
Warning! The maximum key length is 900 bytes. The index 'uk_group_attr_name_lval' has maximum length of 1029 bytes. For some combination of large values, the insert/update operation will fail.
Warning! The maximum key length is 900 bytes. The index 'idx_mem_dir_parent_child' has maximum length of 1149 bytes. For some combination of large values, the insert/update operation will fail.
Warning! The maximum key length is 900 bytes. The index 'idx_user_attr_dir_name_lval' has maximum length of 1029 bytes. For some combination of large values, the insert/update operation will fail.
Warning! The maximum key length is 900 bytes. The index 'deadletter_msg_server_folder' has maximum length of 1029 bytes. For some combination of large values, the insert/update operation will fail.
Warning! The maximum key length is 900 bytes. The index 'entpropindexdoc_module' has maximum length of 1020 bytes. For some combination of large values, the insert/update operation will fail.
Warning! The maximum key length is 900 bytes. The index 'licenserolegroup_index' has maximum length of 1020 bytes. For some combination of large values, the insert/update operation will fail.
Warning! The maximum key length is 900 bytes. The index 'managedconfigitem_id_type_idx' has maximum length of 1020 bytes. For some combination of large values, the insert/update operation will fail.

      How can I fix it?

            Assignee:
            Unassigned
            Reporter:
            Maxim Zaripov
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: