Skip to main content
Solved

ENUM Data type now showing

  • 12 June 2024
  • 2 replies
  • 23 views

When attempting to connect to the MySQL database using the ODBC Connector, we are encountering an issue where ENUM data type fields are not displaying. However, when manually inserting the field headers into the query, the values are visible.

2 replies

Christian Hauggaard
Rank
Userlevel 6
Badge +5

Hi @panil, can you please share the create statement of your table in MySQL that contains the ENUM data type? Also please share some of the values that these fields contain

Please confirm which version of TimeXtender you are using and if you are using ODX or business unit

You mention that “When manually inserting the field headers into the query, the values are visible.” are you referring to the query tool / query tables?

 

Christian Hauggaard
Rank
Userlevel 6
Badge +5

Hi @panil could you please provide an update on the questions above?

Reply


Terms and ConditionsCookie settings