Search Postgresql Archives

RE: Bind Parameter is Too Big

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 database uses UTF8



Matt Kluzak
Technology Director
North Dakota Public Service Commission
600 E Boulevard Ave
Dept 408 13th Floor
Bismarck, ND  58505-0480
Phone: 701-328-4075

-----Original Message-----
From: Adrian Klaver <adrian.klaver@xxxxxxxxxxx> 
Sent: Thursday, September 01, 2022 3:46 PM
To: Kluzak, Matthew C. <mckluzak@xxxxxx>; pgsql-general@xxxxxxxxxxxxxxxxxxxx
Subject: Re: Bind 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 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 the generated SQL 
> statement files. Other staff then uses a PB2019R3 app to pipe the data 
> to a master Sybase ASE 15.7 database. At the beginning of each week 
> that data is piped via PB2019R3 app to another Sybase ASE 15.7 
> database. The inspectors then update their Postgres database with all 
> inspectors' data via another PB2019R3 app that pipes the data from Sybase to Postgres.
>
>   * Yes, I understand how absurd the system is. I just inherited it and
>     am supporting it until we can replace it.

The .gov domain was explanation enough.

> However, when trying to pipe the data from Sybase 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)."

What is the actual code that pipes the data?

What is the encoding/character set in Sybase vs Postgres?

>
> Via Appeon's support forums I worked out getting the pipe to work in 
> the PowerBuilder IDE by enabling staticbind and disablebind. In this 
> view, I can get a connection string to use in the app's configuration file.
> However, using this connection string in the app's configuration file 
> still doesn't work when running the pipe in the app.
>
> Connection string is:
> DBParm=ConnectString='DSN=WM_LT_User;UID=user;PWD=password',PBCatalogO
> wner='user',DelimitIdentifier='Yes',DisableBind=1
>
> Appeon is claiming it is a Postgres issue and so I am inquiring here. 
> I am hoping someone can help steer me in the right direction to get 
> this pipe working.
>
> Thanks
>
> Matt Kluzak
>
> Technology Director
>
> North Dakota Public Service Commission
>
> 600 E Boulevard Ave
>
> Dept 408 13^th Floor
>
> Bismarck, ND  58505-0480
>
> Phone: 701-328-4075
>
>
> ----------------------------------------------------------------------
> -- This transmission, email and any files transmitted with it, may be: 
> (1) subject to the Attorney-Client Privilege, (2) an attorney work 
> product, or (3) strictly confidential under federal or state law. If 
> you are not the intended recipient of this message, you may not use, 
> disclose, print, copy or disseminate this information. If you have 
> received this transmission in error, notify the sender (only) and 
> delete the message.
> This message may also be subject to disclosure under the North Dakota 
> Open Records Laws.
>


--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx






[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux