support for unsigned integers

[SeanAdams]

Hi all,

Based on the thread here https://community.alteryx.com/t5/Data-Preparation-Blending/Support-for-unsigned-int-database-type/m-... - there would be value in natively supporting the Unsigned Int data type in Alteryx.   

This idea was raised by @jgreene.

Note: this does appear to be directly supported in the core OCBC library (as long as it's supported by the ODBC driver for the specific database in question), so hopefully this won't be a huge lift:

https://docs.microsoft.com/en-us/sql/odbc/reference/appendixes/sql-data-types

@jgreene- would you mind adding any further information about the DBMS you are using which supports unsigned int, and any other info that may help the team to develop and test this (e.g. any link you can find to an available ODBC driver for this database etc?)

Thank you

Sean

[jgreene]

We're using MySQL and the 5.3.7 64-bit ODBC Driver for Windows available here:

https://dev.mysql.com/downloads/connector/odbc/

[Rich_U]

Any movement on this native MySQL functionality?  I'm trying to use the Create New Table in an output so I can match the database I'm importing data from and cannot create the BIGINT UNSIGNED field type, due to unsigned not being supported.  Thanks.