I have a table:
CREATE TABLE "CENIK"
(
"NAZEV" VARCHAR(50) CHARACTER SET WIN1250 COLLATE PXW_CSY,
"C_VYR" VARCHAR(30) CHARACTER SET WIN1250 COLLATE PXW_CSY,
"NOMENKLATURA" VARCHAR(30) CHARACTER SET WIN1250 COLLATE
PXW_CSY,
...

I need collation on columns, because I access database through ODBC
driver and without collating sorting is bad.

I can't create index:
CREATE INDEX DUPL7
ON "CENIK"(
"NOMENKLATURA",
"C_VYR",
"NAZEV"
)
;


Unsuccessful metadata update
key size too big for index DUPL7
Statement: CREATE INDEX DUPL7
ON "CENIK"(
"NOMENKLATURA",
"C_VYR",
"NAZEV"
)

There is some internal limit on index key soze, about 60 char if
collating is used and it is too small, (about 255 chars without
collating).

Is there any workaround?