KNOWLEDGE BASE

Error "unknown collation 'en_MY_CI' [SQL State: 42601]" Connecting to Excel


Published: 07 Feb 2018
Last Modified Date: 08 Feb 2018

Issue

When trying to connect to a Microsoft Excel file in Tableau Desktop 10.5, the following error may occur:
 
[4] PQresultStatus: 7 ERROR: unknown collation 'en_MY_CI' [SQL State: 42601] [Severity: ERROR] [Primary message: unknown collation 'en_MY_CI']

Environment

  • Tableau Desktop 10.5
  • Microsoft Excel

Cause

This behavior is related to a known issue, ID 708613, which is expected to be fixed in a future release.
Did this article resolve the issue?