Главная страница | назад

Article #20180: Garbage added to end of Memo field with ODBC connection

When the BDE inserts blob data into a table via an ODBC connection it indicates the length of the blob via a size parameter. Some ODBC drivers ignore this parameter and attempt to determine the size by looking for a NULL character instead. ODBC drivers which are reported to operate this way are Advantage and PostgreSql. This may result in garbage appearing at the end of the blob. To resolve the problem obtain an updated ODBC driver from the ODBC vendor which determines the size via the parameter, not by looking for a NULL.

Last Modified: 01-DEC-99