Subject views
Author kaczy27
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