I support a system where inspectors use a PB2019R3 app to enter data into a Postgres 12 database and then generates SQL statements for the data and saves as a text file. The inspectors use another PB2019R3 app to populate a Sybase 15.7 database with the generated SQL statements. They then update their Postgres database with all inspectors' data via another PB2019R3 app that pipes the data from Sybase to Postgres.

I recently updated two comment columns in two tables, both on the Sybase and Postgres sides, from varchar (255) to varchar(1000). I can successfully input data with up to 1000 characters to the updated columns in Postgres and then insert the generated SQL statements into Sybase. However, when trying to pipe it back to Postgres I get the error "Bind Parameter for value :9 is Too Big (2000)." The comment column is the 9th column.

I checked the data and verified it isn't over the 1000 character limit. I tried deleting out 13 of the 1000 characters, and the error this time was "Bind Parameter for value :9 is Too Big (1976)."

Could someone indicate what's wrong and a possible solution?

Thanks