Skip to main content
To homepage To homepage
Solved

ENUM Data type now showing

P
Visitor

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.

Best answer by Christian Hauggaard

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?

 

View original
    Did this topic help you find an answer to your question?

    2 replies

    Christian Hauggaard
    Community Manager
    Forum|alt.badge.img+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
    Community Manager
    Forum|alt.badge.img+5

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

    Reply


    Most helpful members this week

    Terms and ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings