Subject | Re: [firebird-support] unknown characters |
---|---|
Author | xuxu |
Post date | 2004-12-01T01:36:50Z |
Help me!
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-12-01
>firebird-support!Using 'select len(accountno_domain) accountno_domain from xx ',I can get this :
>
> 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
>----------------------------------------------------------------------------------------------
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