Query Long Varchar via ODBC
I want to query a table's content that has a 'Long Varchar' data type.
I tested via vsql and it fetched whole data. but isql cannot fetch more than 300 bytes!!!
Also tested via PHP but it fetched only 65535 bytes!!
I guess this is an odbc limitation, Is there any configuration for it?
How can i fetch the field completely in PHP?
Vertica version: 9.2
Vertica Driver: 9.2
unixodbc version: 2.2.14p2-5ubuntu5
Php5-odbc version: 5.5.9