I'm using PDO to extract data from Teradata, using an ODBC connect string.
The query returns the correct number of rows but column 5 onwards is blank (as compared to using the same query with the PHP ODBC library)
Column 5 happens to be a varchar(400) field and I've read that PDO had bugs in the past with varchar columns > 255 in length.
I could workaround this by CASTing the varchar column to varchar(255) but is there a better approach? Should I raise a bug against the PDO library (don't really want to wait that long for a bug fix though)?
I want to continue using PDO so that my extract routines are the same across different RDBMSs (SQL server, Oracle, etc)...