|Subject||Re: [firebird-support] Three trailing spaces?|
On 12 December 2014 at 13:55, Tim Ward tdw@... [firebird-support] <email@example.com> 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
CHECK (VALUE IN ( 'A', 'U', 'D', 'M', 'S' ))
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
I get the string
(three spaces after the A). Yes this may be a PHP question, but just in
case it isn't, any ideas?