Subject | views |
---|---|
Author | kaczy27 |
Post date | 2004-11-05T16:08:31Z |
Hi
I've hit a strange behaviour of FB 1.5.1 on winXP
problem might be the IB Expert I am using, but to the point:
I am creating a view from few tables.
the table contain field defined as follows:
PARAMETER_NAME DN_NAME
the domain is defined as follows
VARCHAR(50) CHARACTER SET UNICODE_FSS
COLLATE UNICODE_FSS
now when I created the view that draw from this field
it is either created as a domain or it is created as a VARCHAR(50)
and the domain is autogenerated and named RDB$1551 (the name change
between compiles)
my application depend on that the fields will be unicoded, so I'd
like to know how to force the view to use the domain.
if I create the same select using stored procedure, I can't use the
domain but I can at least force it to be varchar(50) unicode_fss.
ideas?
CUIN Kaczy
I've hit a strange behaviour of FB 1.5.1 on winXP
problem might be the IB Expert I am using, but to the point:
I am creating a view from few tables.
the table contain field defined as follows:
PARAMETER_NAME DN_NAME
the domain is defined as follows
VARCHAR(50) CHARACTER SET UNICODE_FSS
COLLATE UNICODE_FSS
now when I created the view that draw from this field
it is either created as a domain or it is created as a VARCHAR(50)
and the domain is autogenerated and named RDB$1551 (the name change
between compiles)
my application depend on that the fields will be unicoded, so I'd
like to know how to force the view to use the domain.
if I create the same select using stored procedure, I can't use the
domain but I can at least force it to be varchar(50) unicode_fss.
ideas?
CUIN Kaczy