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