Hello:

> That would figure, because you can't have collations in arrays, so there's
> no reason to pass the sqlsubtype.

OK, But, can i define an char array field with a character set different
than database character set ??

I can define a column as:

ALTER TABLE TEST_TABLE_01
ADD UCCHAR_ARRAY CHAR(10)[1:10] CHARACTER SET UNICODE_FSS
COLLATE UNICODE_FSS

I don't know if firebird will use the character set and collation for
this field, ( i have interest only in the character for allow correct
encoding of strings in the .net provider ) but, if it's being used, i
think that would be useful to pass the sqlsubtype too for char and
varchar array fields too.


--
Best regards

Carlos Guzmán Álvarez
Vigo-Spain