does db2 8.1 support collations?
If yes please give the syntax for it.

What is it? Please describe.

I have used this in SQL server

Collation refers to a set of rules that determine how data is sorted and compared. Character data is sorted using rules that define the correct character sequence, with options for specifying case-sensitivity, accent marks, kana character types and character width.



db2 has similar concept using a combination of different things, during
database creation like codeset , collate using system/identity.

Please check the IBM manual before using any of these options.

regards,

mujeeb