Free Trial

Alteryx Server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.

Increase field length while connecting to datasource in Gallery

ajakshayjha
5 - Atom

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?

1 REPLY 1
c-lopez
Alteryx
Alteryx

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.

 

c-lopez_0-1594831076180.png