I have an application which accesses some VARCHAR(256) fields in mySQL. When the user enters data, it is correctly stored in these fields. But whenever I retrieve it for reporting it is truncated to 127 characters.

Any ideas on this?

how do you know it is being truncating to 127?

post some code, and tell us what debugging you’ve done so far