Increase field length while connecting to datasource in Gallery

Question

I am trying to connect to a datasource using a odbc connection string & publishing that in alteryx gallery.ODBC Connection has default string length of 255 characters. I can change that length in my personal laptop but how to update the length in alteryx gallery?

c-lopez · Answer

Hi @ajakshayjha,

By default your database will store all of its date in one of these primitives:

CHAR

A fixed-length string that is always right-padded with spaces to the specified length when stored The range of Length is 1 to 255 characters. Trailing spaces are removed when the value is retrieved. CHAR values are sorted and compared in case-insensitive fashion according to the default character set unless the BINARY keyword is given.

VARCHAR

A variable-length string. Note: Trailing spaces are removed when the value is stored (this differs from the ANSI SQL specification)
The range of Length is 1 to 255 characters. VARCHAR values are sorted and compared in case-insensitive fashion unless the BINARY keyword is given

TINYBLOB, TINYTEXT

A TINYBLOB or TINYTEXT column with a maximum length of 255 (28 - 1) characters

BLOB, TEXT

A BLOB or TEXT column with a maximum length of 65,535 (216 - 1) characters , bytes = 64 KiB

MEDIUMBLOB, MEDIUMTEXT

A MEDIUMBLOB or MEDIUMTEXT column with a maximum length of 16,777,215 (224 - 1)characters , bytes = 16 MiB

LONGBLOB, LONGTEXT

A LONGBLOB or LONGTEXT column with a maximum length of 4,294,967,295 (232 - 1) characters , bytes = 4 GiB

This means that when you read from your database it will always serve up the data in one of those default sizes, if you want to change the size you would need to add a select tool after the ODBC data input and change the size at that point.

When you upload this to Server your variables should have the size you assigned on the workflow.