firebird-support!

There is some unknown charecters following the string-value in my table named xx.

--MY TABLE--------------------------------------------------------------------------------
CREATE DOMAIN NUMBER_2 AS
VARCHAR(30) CHARACTER SET NONE
NOT NULL
COLLATE NONE

create table xx(
DOMAINNO INTEGER NOT NULL,
ACCOUNTNO_DOMAIN NUMBER_2 NOT NULL,
USERTYPE CHAR(1) NOT NULL
) ;

--data----------------------------------------------------------------------------------------
Using 'select * from xx',I can get this :
DOMAINNO ACCOUNTNO_DOMAIN USERTYPE
============ ============================== ========
17 826621 B
17 911090
B
----------------------------------------------------------------------------------------------
Using "select * from xx where accountno_domain = '826621' or accountno_domain like '911090'||'%' ",I can get the
result successfully! But when I use "select * from xx where accountno_domain = '826621' or accountno_domain = '911090'",I can't get the result where accountno_domain = '911090'.



　　　　　　　　xuxu
　　　　　　　　xufh@...
　　　　　　　　　　2004-11-30