LAE

Welcome to the LAE community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Discussions

Members

Resources

Events

 View Only
Back to discussions
Expand all | Collapse all

ODBC truncating to 255 chars

  • 1.  ODBC truncating to 255 chars

    Employee
    Posted 10-13-2015 02:55

    Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

    Originally posted by: duffbry

    Hi,

    I'm using an ODBC connection to pull in some simple data. One of the fields I am pulling back can have strings of up to 800+ characters however using the ODBC node the field is truncated to 255 characters. At first I thought this was an issue with the database storage as I'm aware some older databases had a limitation of 255 characters max. However, when I pull the same query with the JDBC node I get the entire strings populated.

    Is this a known issue and / or is there a workaround other than the JDBC node?

    Thanks.