[firebird-support] Three trailing spaces?

[Tim Ward t...@telensa.com [firebird-support]]

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