| Subject: | Ingres long byte sent by Perl DBD::Ingres as long varchar |
The Perl application is trying to insert a blob into Ingres r3. Specifically, the column in the database is defined as a long byte (hence, it is binary, not character). The application is trying to insert a value as SQL_LONGVARBINARY, which seems correct. However, it appears that the value is actually being sent as an Ingres long varchar rather than a long byte. All character data (such as long varchar) goes through Ingres/Net character set conversion when sending/receiving data between heterogeneous systems, which the user is trying to do (Windows<->Linux). As a result, some of the data in the blob is getting modified and it shouldnt. It would appear that the Perl DBD::Ingres driver is mapping SQL_LONGVARBINARY to Ingres long varchar instead of Ingres long byte. If the value were mapped to Ingres long byte, then no data conversion would take place and we believe the program would work correctly.
Message body not shown because it is not plain text.