Error 8 Hy000 Unsupported Data Type
you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. + Reply to Thread Results 1 to 4 of 4 Thread: ENUM: Unsupported data type? Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode October 28th, 2008,07:09 AM #1 cvh@LE View Profile View Forum Posts Private Message Senior Member Join Date Oct 2008 Posts 73 ENUM: Unsupported data type? Hi, I just realised that brighthouse doesnt seem to support enum-columns.: mysql> create table test (tc1 enum('a','b') null ); ERROR 8 (HY000): Unsupported data type. What other datatypes are not supported? Does this include SET, too? What about other string / numeric data types, types of the spatial extension? CVH Reply With Quote October 28th, 2008,07:25 AM #2 john View Profile View Forum Posts Private Message Senior Member Join Date Aug 2008 Posts 82 ENUM: Unsupported data type? Hi Chris, The data types supported by Infobright can be found in the wiki here: http://www.infobright.org/wiki/Supported_Data_Types_and_Values/ Regards, Reply With Quote October 28th, 2008,07:46 AM #3 jakubw View Profile View Forum Posts Visit Homepage Senior Member Join Date Aug 2008 Posts 689 ENUM: Unsupported data type? Hi Chris, From performance perspective, enum may be emulated by varchar(...) comment 'lookup' . It stores varchar values in dictionary and internally uses numbers. But you cannot check validity of input values in this way. Best regards, Reply With Quote October 28th, 2008,08:21 AM #4 cvh@LE View Profile View Forum Posts Private Message Senior Member Join Date Oct 2008 Posts 73 ENUM: Unsupported data type? Thanks Jakub, Exactly what I wanted to know. Thanx Chris Reply With Quote + Reply to Thread Quick Navigation ICE Q&A Top Site Area
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Error loading SQL_VARIANT data type using https://www.infobright.com/forums/showthread.php?5536-ENUM-Unsupported-data-type Python up vote 4 down vote favorite I am using Python and SQLAlchemy to query a database that I did not create. I have run into a problem querying a table that contains the SQL_VARIANT data type. I get the error: sqlalchemy.exc.DBAPIError: (Error) ('ODBC data type -150 is not supported. Cannot read column Value.', 'HY000') I confirmed with the database creator that the "Value" column is of http://stackoverflow.com/questions/17354042/error-loading-sql-variant-data-type-using-python type SQL_VARIANT. Does anyone know a way to load this data type using Python? I am currently using mssql with pyodbc. Thank you for any help you can offer! Versions: Python 2.7, SQLAlchemy 0.7.8 python sqlalchemy share|improve this question edited Jun 27 '13 at 22:19 alecxe 216k33244414 asked Jun 27 '13 at 22:08 Brett D 212 What is connection string you are giving to SQLAlchemy? SQLA supports SQL_VARIANT so it looks to be a problem with the driver you are using to connect to the db. –davidism Jun 30 '13 at 18:08 Thanks for the response @davidism. My connections string is: 'mssql+pyodbc://user:password@IPAddress/database' –Brett D Jul 1 '13 at 17:41 How is this working with MSSQL? PyODBC needs a driver like FreeTDS to talk to MSSQL. A connection string I have used looks like: mssql://user:pass@host:port/db?driver=FreeTDS&tds_version=7.2. –davidism Jul 1 '13 at 19:27 I can't say that I fully understand how everything is working, but the connection string above has allowed me to connect to and query the database. According to the MSSQL page on the SQLAlchemy website (docs.sqlalchemy.org/en/rel_0_7/dialects/mssql.html), my connection string would result in a connection of the form: DRIVER={SQL Server};Server=IPAddress;Database=d
464339 Comments 28 Status Active Workarounds 2 Type Bug Repros 10 Opened 6/4/2009 7:22:24 PM Access Restriction Public Description When I run the query below on any of our https://connect.microsoft.com/SQLServer/feedback/details/464339/unsupported-data-type-reported-for-supported-data-types-in-nested-query databases, the field InventoryItemsAuditTrailID is reported as an