Re: Problem dbi_link with postgresql 9.04

Emanuel Araújo wrote:
> The field where the problem occurs is of type float or double, when extracting data from firebird, it
> creates the tables materialized as type text. There is problem with null values ​​or zero bytes. There
> are three records with value "1.5" and are those records that generates the error.

>> What I would do is check how the data look in Perl.
>> Build a simple Perl script that selects the problem data and display them byte for byte.
>>
>> That should help understand the problem.

> I will try

Another possibility is to use the 8.4 installation where things work
and display the actual content with something like:

SELECT encode(col, 'escape') FROM tab WHERE ...

That should show any zero bytes.

Yours,
Laurenz Albe