[RSS Feed/News] discussion_type is varchar instead of varbinary, and may cause collation issues on join

Status
Not open for further replies.

XenForo

Administrative
  • Thread starter
  • Admin
  • #1
In XF2.2+, the new xf_thread_type.thread_type_id as varbinary. However the existing xf_thread.discussion_type table this is varchar.

Despite these columns being logically the same, joining from varbinary to varchar can cause and illegal mix of collations, but only on some installations which may make diagnosing harder than it needs to be.

ادامه مطلب...
 
Status
Not open for further replies.
Back
Top Bottom