I've got a column defined as

MODACTION D_MODACTION ,

where the domain is defined as

CREATE DOMAIN D_MODACTION AS
CHAR(1) CHARACTER SET ASCII
NOT NULL
CHECK (VALUE IN ( 'A', 'U', 'D', 'M', 'S' ))
COLLATE ASCII;

I've got a record which appears to have 'A' in this field.

But when I do a "SELECT * FROM ..." (from PHP using ibase_fetch_assoc) I
don't get the string

'A'

I get the string

'A '

(three spaces after the A). Yes this may be a PHP question, but just in
case it isn't, any ideas?

--
Tim Ward