> and another trouble we have
> got is the ordering of the letters like "á" just be right after the common
> "a" and not after "z".

If you use ISO8859_1 you can order by using COLLATE FR_FR (if you use
WIN1252 you can use the Collation PXW_INTL850).

You can define the collation order with the domains, too, like:.

CREATE DOMAIN T_SURNAME VARCHAR(30) [CHARACTER SET ISO8859_1] COLLATE
FR_FR;

(You only have to define the character set for domains if it differs
from the default character set of the database itself (as specified in
CREATE DATABASE)).


But keep in mind that collation orders eat up some bytes (approx. two
third) of the maximal INDEX length; so I recommend you use this
collation order just on fields you're really ordering frequently ....

(ie if you have a varchar field that has a collation FR_FR then you can
only index it if, if it's smaller than a VARCHAR(83); if it's a
combined index with more than one field the maximal index length is even
shorter.)

Luc.