On Fri, 12 Dec 2014 13:55:16 +0000, "Tim Ward tdw@...
[firebird-support]" <firebird-support@yahoogroups.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
> 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