| Subject | Re: [firebird-support] Three trailing spaces? |
|---|---|
| Author | Nick Upson |
| Post date | 2014-12-12T14:06:10Z |
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 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?
--
Tim Ward