if you use isql or dbworkbench to do the same query, that will tell you if the problem is php or firebird
Nick Upson, Telensa Ltd, Senior Operations Network Engineer direct +44 (0) 1799 533252, support hotline +44 (0) 1799 399200 On 12 December 2014 at 13:55, 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? > > -- > Tim Ward > > >
