RE: Bind Parameter is Too Big

2022-09-16 Thread Kluzak, Matthew C.
idn't have an explanation either. -Original Message- From: Tom Lane Sent: Thursday, September 01, 2022 4:03 PM To: Kluzak, Matthew C. Cc: Adrian Klaver ; pgsql-general@lists.postgresql.org Subject: Re: Bind Parameter is Too Big * CAUTION: This email originated from an outside

Re: Bind Parameter is Too Big

2022-09-01 Thread Tom Lane
"Kluzak, Matthew C." writes: > The Sybase databases use > Character Set = 1, iso_1 > ISO 8859-1 (Latin-1) - Western European 8-bit character set. > Sort Order = 50, bin_iso_1 > Binary ordering, for the ISO 8859/1 or Latin-1 character set ( > iso_1). > The Postgres database uses UTF8

Re: Bind Parameter is Too Big

2022-09-01 Thread Adrian Klaver
On 9/1/22 1:51 PM, Kluzak, Matthew C. wrote: Hi Adrian, The Sybase databases use Character Set = 1, iso_1 ISO 8859-1 (Latin-1) - Western European 8-bit character set. Sort Order = 50, bin_iso_1 Binary ordering, for the ISO 8859/1 or Latin-1 character set ( iso_1). The Postgres

RE: Bind Parameter is Too Big

2022-09-01 Thread Kluzak, Matthew C.
Parameter is Too Big * CAUTION: This email originated from an outside source. Do not click links or open attachments unless you know they are safe. * On 9/1/22 1:34 PM, Kluzak, Matthew C. wrote: > I support a system where staff use a PowerBuilder 2019R3 app that > enters data

Re: Bind Parameter is Too Big

2022-09-01 Thread Tom Lane
"Kluzak, Matthew C." writes: > I recently updated two comment columns in two tables, both on the Sybase and > Postgres sides, from varchar (255) to varchar(1000). The app can succesfully > input data with up to 1000 characters to the updated columns in Postgres. The > generated SQL statement fi

Re: Bind Parameter is Too Big

2022-09-01 Thread Adrian Klaver
On 9/1/22 1:34 PM, Kluzak, Matthew C. wrote: I support a system where staff use a PowerBuilder 2019R3 app that enters data into a Postgres 12 database, generates SQL statements for the data and saves them as text files. Staff uses another PB2019R3 app to populate a Sybase ASE 15.7 database with