Community Manager
Community Manager


  • Strings read from EXA using PHP via ODBC are truncated.
  • PHP throws truncation errors while reading Strings from EXA via ODBC
  • Unicode Strings cannot be displayed or are truncated


You are using PHP on NIX and the PHP is not working properly when using special characters. PHP reads the column attribute displaySize and uses it as octetLength while allocating SQLFetch and SQLGetData buffers. For Unicode strings this buffers may be too small. You can see this in the verbose EXA ODBC logfile (Logmode=verbose).


You can use the EXA ODBC connection string attribute CHARACTERDISPLAYSIZE=4 to set a display size of 4 for each character in strings, so if displaySize is read by PHP it will get displaySize*CHARACTERDISPLAYSIZE and it will allocate larger buffers.

Additional References

Version history
Revision #:
1 of 1
Last update:
‎22-06-2020 02:59 PM
Updated by: