[Info-ingres] E_AD5015 what?

[Martin Bowes]

Hi All,

I'm processing some data which instead of an empty string has been provided with a C-like end of string marker x'00'. I'm not allowed to alter this data.

So I've allowed for this with a view which does:

    CASE WHEN g.quantity_v <> 2 THEN NULL
         WHEN g.quantity = X'00' THEN ''
         ELSE g.quantity
    END AS quantity

When I use the view to select the data I get greeted with:
E_AD5015 000000B7, is not a valid byte sequence for server codepage.

If I remove the X'00' part of the statement then it runs without error, but I get the crappy data.

Any Ideas?

Martin Bowes
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.planetingres.org/pipermail/info-ingres/attachments/20190907/c703d6bb/attachment.html>