Subject | Changing collation of a existing column |
---|---|
Author | Christian Kaufmann |
Post date | 2003-09-19T14:52:19Z |
Hi,
I have to alter a column from
varchar(n) character set ISO8859_1
to
varchar(n) character set ISO8859_1 collate DE_DE
because it's not directly supported with SQL, I tried to manipulate the
RDB$... tables. I changed in RDB$RELATION_FIELDS the column
RDB$COLLATION_ID. That didn't have any effect on the order command. Do I
have to change it somewhere else?
cu Christian
I have to alter a column from
varchar(n) character set ISO8859_1
to
varchar(n) character set ISO8859_1 collate DE_DE
because it's not directly supported with SQL, I tried to manipulate the
RDB$... tables. I changed in RDB$RELATION_FIELDS the column
RDB$COLLATION_ID. That didn't have any effect on the order command. Do I
have to change it somewhere else?
cu Christian