On Fri, 12 Dec 2014 13:55:16 +0000, "Tim Ward [email protected] [firebird-support]" <[email protected]> wrote: > 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? What is the default character set of your database (if I had to guess it is UTF8), and what is your connection character set (if I had to guess it's NONE or not specified)? Mark
