Hi,

> I went through the following steps in sql:
> ...
> INSERT INTO
> MARC_TO_UCS2_TEMP(US_MARC,UNIMARC,MARC_FINAL_CHARACTER,
> MARC_CODE_POINT,UCS2_CODE_POINT,DESCR) SELECT
> US_MARC,UNIMARC,MARC_FINAL_CHARACTER,MARC_CODE_POINT,
> UCS2_CODE_POINT,DESCR from MARC_TO_UCS2;

Check table after this point. It should already contain padded data.
This problem was discussed in firebird-devel list as is considered as
server bug, however, as I understood, no fix will be available in FB 1.5.

> Incidentally,
> when I accessed the data with Interbase driver, it seemed to work
> fine.

They have created workaround for this problem by trimming or padding
data to the correct size depending on the server response.

I still prefer to have no workarounds for the server bugs in the
driver, since I feel that this is not the right way to solve the
problem (for example, it will remove the pressure from engine
developers to fix it :)). However if community votes to implement such
workaround, I will do that.

Best regards,
Roman Rokytskyy