Hi

I'm using firebird 1.0. I have some select statements which returns
the bug

arithmetic exception, numeric overflow, or string truncation
Cannot transliterate character between character sets

My database and connection is with Character set ISO8856_1.

My table has the following fields:
ParamID: Numeric(18, 0)
ParamName: VarChar(10) ISO8856_1
ParamDesc: VarChar(40) ISO8856_1

I get the error with the following statement:
SELECT DISTINCT ParamID || ParamDesc FROM Param

I don't get the error with the following statements:
SELECT ParamID || ParamDesc FROM Param (without Distinct)
SELECT DISTINCT ParamID || ParamName FROM Param (with VarChar(10) than
VarChar(40))
SELECT DISTINCT ParamDesc || ParamID FROM Param (different field order)
SELECT DISTINCT ParamName || ParamDesc FROM Param (only varchar fields)

For me it seems to be a bug or is it "by design"? Has someone some
background information about the internal reason for this behavior?

The bad side about this bug is that IBObjects internally uses such
kind of select statements. So I cannot avoid is so easily.

Cheers
Daniel