Subject Re: [firebird-support] unknown characters
Author xuxu
Help me!
>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 len(accountno_domain) accountno_domain from xx ',I can get this :
LEN ACCOUNTNO_DOMAIN
=========== ================
6 826621
8 911090
-----------------------------------------------------------------------------------------------
Using 'select len(rtrim(acccounto_domain)) accounnto_domain from xx',I can get this:
LEN ACCOUNTNO_DOMAIN
=========== ================
6 826621
8 911090
-----------------------------------------------------------------------------------------------
What are the two characters following '911090' ? Help me!

>
>
>
>        xuxu
>        xufh@...
>          2004-11-30
>
>
>
>
>
>
>Yahoo! Groups Links
>
>
>
>

= = = = = = = = = = = = = = = = = = = =


        致
礼!


        xuxu
        xufh@...
          2004-12-01